DateTime functions in SQL Server Part 25

Công Nghệ

In this video we will learn about different DateTime data types, and different date time functions in sql server. We will also understand the difference between terms UTC (Coordinated Universal Time) and Time Zone offset.

Text version of the video


All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic


Xem thêm bài viết khác:

28 thoughts on “DateTime functions in SQL Server Part 25

  1. In a table i have two columns name and date of can we find the date of birth is todays date?kindly help me out

  2. If someone wants quick explanation of why UTC, not CUT: UTC favors neither English nor French. Also, UTC is not GMT, because UTC is not an actual timezone.

  3. worth to watch
    totally outstanding kudos to u sir
    u r making developers life one step ahead
    u r my best tutor 🙂

  4. Hello, can u help me with one exercise. I have table with many dates. I need to pick this records which month and year is the same as the Min Date. I hope u will help me, thank u.

  5. Hello Venkat. I am using SQL server 2005 and i don't know where to find data types like: date(7), datetimeoffset(7), as you used. Most of functions, doesn't work for me.Any suggestions ? PS: you doing a great job ! 

  6. that was an enlightening session.
    i have a problem.
    i am using sql server 2005.
    and it is giving me most of the data types as datetime or smalldatetime.
    some of the functions are also not working for me.
    mine is windows vista which is not showing me utc time as well.
    any suggestion.

  7. Thank you very much for taking time to give feedback. For email alerts, when new videos are uploaded, please subscribe to my channel. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video.

Leave a Reply

Your email address will not be published. Required fields are marked *