?
Solved

VB.net SQL adding Date and Time to DateTime column

Posted on 2014-11-11
2
Medium Priority
?
195 Views
Last Modified: 2014-11-16
Hi

What VB.net code would  use to add a SQL record that shows the date and time right now in
a DateTime field
0
Comment
Question by:Murray Brown
2 Comments
 
LVL 71

Accepted Solution

by:
Éric Moreau earned 2000 total points
ID: 40434840
You should use the GetDate() method of SQL. To test it, run:

SELECT Getdate()

Open in new window

0
 

Author Closing Comment

by:Murray Brown
ID: 40445614
Thanks
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question