How to get a system date | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to get a system date

I was in SQL Server 2000, i need to upload a data to SQL Table with the condition of generate a system date from SQL Server, and from the system date minus 14 days. How should i get this result?? Thank you! Onn
GETDATE() –System Date
DATEADD(DD,-15,GETDATE()) –System Date-14 days. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
]]>