adding current date in the table

[#1]

Hello Friends,

As I have a table and I would like to insert a current date field in the table

How to add the today date in the sql select script

Set Date = Today()

SQL

SELECT

          Date,

          Customer,

    Customer_id,

    Count(Test) as NumInv,

    Sum(Test1) as TotAmt

FROM Scxxx9023;

Regards

Chriss

[kumarnatarajan · Accepted solution]

Hi,

Try This.

SQL

SELECT

          Now() as Today,

          Date,

          Customer,

    Customer_id,

    Count(Test) as NumInv,

    Sum(Test1) as TotAmt

FROM Scxxx9023;

Ex: Now() as Today

Refer Below mentioned URL:

http://www.w3schools.com/sql/sql_dates.asp

[#3]

Hi Kumar,

Thanks for your help, it works.....

Regards

Chriss