Board index » delphi » SQL Server: INSERT INTO ... system date

SQL Server: INSERT INTO ... system date

In Oracle, SYSDATE can be used inside a SQL insert statement.

What is the equivalent in MSSQL ?

Thanks

 

Re:SQL Server: INSERT INTO ... system date


MSSQL equivalant is GetDate like

select Today = GetDate()

Greetings

Willie Marais

Quote
PC Leung <dle...@ouhk.edu.hk> wrote in message news:3a98db0b_1@dnews...
> In Oracle, SYSDATE can be used inside a SQL insert statement.

> What is the equivalent in MSSQL ?

> Thanks

Re:SQL Server: INSERT INTO ... system date


Thank you

It works

Quote
Willie Marais wrote in message <3a98ec7c_1@dnews>...
>MSSQL equivalant is GetDate like

>select Today = GetDate()

>Greetings

>Willie Marais

>PC Leung <dle...@ouhk.edu.hk> wrote in message news:3a98db0b_1@dnews...
>> In Oracle, SYSDATE can be used inside a SQL insert statement.

>> What is the equivalent in MSSQL ?

>> Thanks

Other Threads