Sql Server query to get database date and UTC Date

Posted by Amatya under Sql Server category on 9/26/2017 | Points: 40 | Views : 2025

Post Code |

Search Codes |

Code Home

Get database date.

select getdate()

Get UTC date.

UTC is the time standard commonly used across the world. The world's timing centers have agreed to keep their time scales closely synchronized - or coordinated - therefore the name Coordinated Universal Time .

select GETUTCDATE()

Thanks
Amatya

Alert Moderator

Bookmark It

Comments or Responses

Latest Code Snipptes

Uber Clone - Taxi Booking App
writing Custom pagination html code in python and django
Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
More ...