Getting the Current Date

[MahalKoCjet]

Hi Gurus,

How could I get the current date using SQL in an access database?


I've seen a version of this in an Informix SQL:
ex."update date_setting set cur_date = today"

But this query doesn't run in an access database.

 

[tomslacks]

I think the simple answer is DATE()

 

[tomslacks]

I forgot to mention DATE() returns the system date when used.

 

[MahalKoCjet]

Hi,
this "DATE()" doesnt work.

What I'm referring to is how to retrieve the current date in a database using SQL.

Any Idea? Please Help

Tenyks

 

[swampBoogie]

update date_setting set cur_date = date()

should work. If you want current time as well you could use

update date_setting set cur_date = now()