How to Use Datetime in SQL - SQL Training Online - Quick Tips Ep33
How to use a Datetime in SQL.
The datetime is actually made up of two different pieces:
1) Date
2) Time
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.
select getdate()
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:
select convert(varchar,hire_date,104)
from employee
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.
If you enjoy the video, please give it a like, comment, or subscribe to my channel.
READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE
http://www.sqltrainingonline.com/
YOUTUBE NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
http://www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
http://www.youtube.com/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
http://www.sqltrainingonline.com
LET'S CONNECT!
Facebook: / sqltrainingonline
Twitter: / sql_by_joey
Linkedin: / joeyblue
SQLTrainingOnline: http://www.sqltrainingonline.com
Watch video How to Use Datetime in SQL - SQL Training Online - Quick Tips Ep33 online without registration, duration hours minute second in high quality. This video was added by user Joey Blue 19 October 2012, don't forget to share it with your friends and acquaintances, it has been viewed on our site 43,872 once and liked it 342 people.