This video is a quick overview of using the SQL Server Datetime function.
The datetime is actually made up of two different pieces:
This can be demonstrated using the SQL Cast function on a string to convert it to a datetime.
Here is some SQL for the Date portion:
select cast('20121019' as datetime)
Here is some SQL for the Time portion:
select cast('10:05:00' as datetime)
Now, you can also simply use the built-in getdate() function to bring back the current system time.
And finally, I want to bring back a datetime from an actual table.
In this case, we will use the employee table from the SQL Training Online Simple DB:
select hire_date from employee
If we want to convert the result to a more formatted string, we will use the TSQL CONVERT function:
In this example, we are converting from a datetime to a varchar (string). The result will be in the format of 104.
To translate 104 to a datetime format, you will want to look at the MSDN Documentation.
And, that is how you use the Datetime SQL.
Let me know what you think by commenting or sharing on twitter, facebook, google+, etc.
Leave a Question, Comment, or Reply. All are welcome!