SQL Server equivalent of MySQL s NOW

Question

I m a MySQL guy working on a SQL Server project  trying to get a datetime field to show the current time   In MySQL I d use NOW   but it isn t accepting that   INSERT INTO timelog  datetime filed  VALUES  NOW

User · Answer

You can also use CURRENT TIMESTAMP  if you feel like being more ANSI compliant  though if you re porting code between database vendors  that ll be the least of your worries   It s exactly the same as GetDate   under the covers  see this question for more on that    There s no ANSI equivalent for GetUTCDate    however  which is probably the one you should be using if your app operates in more than a single time zone

User · Answer

getdate   or getutcdate

User · Answer

getdate      is the direct equivalent  but you should always use UTC datetimes  getutcdate     whether your app operates across timezones or not - otherwise you run the risk of screwing up date math at the spring fall transitions

User · Answer

You can also use CURRENT TIMESTAMP  if you feel like being more ANSI compliant  though if you re porting code between database vendors  that ll be the least of your worries   It s exactly the same as GetDate   under the covers  see this question for more on that    There s no ANSI equivalent for GetUTCDate    however  which is probably the one you should be using if your app operates in more than a single time zone

User · Answer

getdate      is the direct equivalent  but you should always use UTC datetimes  getutcdate     whether your app operates across timezones or not - otherwise you run the risk of screwing up date math at the spring fall transitions

User · Answer

You can also use CURRENT TIMESTAMP  if you feel like being more ANSI compliant  though if you re porting code between database vendors  that ll be the least of your worries   It s exactly the same as GetDate   under the covers  see this question for more on that    There s no ANSI equivalent for GetUTCDate    however  which is probably the one you should be using if your app operates in more than a single time zone

User · Answer

SYSDATETIME   and SYSUTCDATETIME    are the DateTime2 equivalents of  GetDate   and GetUTCDate     which return a DateTime   DateTime2 is now the preferred method for storing the date and time in SQL Server 2008   See the following StackOverflow Post

User · Answer

SYSDATETIME   and SYSUTCDATETIME    are the DateTime2 equivalents of  GetDate   and GetUTCDate     which return a DateTime   DateTime2 is now the preferred method for storing the date and time in SQL Server 2008   See the following StackOverflow Post

User · Answer

getdate      is the direct equivalent  but you should always use UTC datetimes  getutcdate     whether your app operates across timezones or not - otherwise you run the risk of screwing up date math at the spring fall transitions

User · Answer

You can also use CURRENT TIMESTAMP  if you feel like being more ANSI compliant  though if you re porting code between database vendors  that ll be the least of your worries   It s exactly the same as GetDate   under the covers  see this question for more on that    There s no ANSI equivalent for GetUTCDate    however  which is probably the one you should be using if your app operates in more than a single time zone

User · Answer

getdate   or getutcdate

User · Answer

getdate      is the direct equivalent  but you should always use UTC datetimes  getutcdate     whether your app operates across timezones or not - otherwise you run the risk of screwing up date math at the spring fall transitions

User · Answer

getdate   or getutcdate

User · Answer

getdate   or getutcdate

[sql] SQL Server equivalent of MySQL's NOW()?

Examples related to sql

Examples related to sql-server