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

Share and Enjoy !

0Shares
0 0

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 *