Sql DateTime

Sql DateTime

In this article we discus about SQL DateTime Format.

SQL Server provides a number of options you can use to SQL DateTime Format. One of the first considerations is the actual date/time needed. The most common is the current date/time using getdate(). This provides the current date and time according to the server providing the date and time. If a universal date/time is needed, then getutcdate() should be used. To change the format of the date, you convert the requested date to a string and specify the format number corresponding to the format needed.


Date Format:

Try This


Add Day

Add month

Add Year

Thank you for reading SQL DateTime Format

3 thoughts on “Sql DateTime

  1. Thanks for your marvelous posting! I seriously enjoyed
    reading it, you are a great author.I will be sure to bookmark your blog
    and may come back later on. I want to encourage you to
    continue your great posts, have a nice morning!

Leave a Reply

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