How do I get system date

[hugonovo]

Hello all!!

I would like to know how do I get the system date on MySQL, with a single query?

Regrads,
Hugo Novo

 

[r937]

which query?

 

[sleipnir214]

SELECT date()

?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[r937]

okay, i just looked it up at mysql.com and you're right, the SELECT statement does not require a FROM clause

the reason i asked Hugo which query was because i'd hate to have to explain how to create an OOAK (one of a kind) table -- similar to oracle's DUAL -- if the current date was actually required along with something else in an existing query

but the FROM-less SELECT works fine

F.Y.I. mysql does not have a DATE() function, it supports the CURRENT_DATE function which is the international standard


rudy

 

[sleipnir214]

You're right.

The query should have been:

SELECT now()



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[r937]

what??!!

Hugo asked for date

now() gives date and time

CURRENT_DATE gives date

 

[sleipnir214]

"date and time" includes the date, doesn't it?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[r937]

sure, but hey, why include stuff that isn't asked for?

[tt]select CURRENT_DATE, MONTHNAME(CURRENT_DATE)[/tt]


rudy

 

[hos2]

perhaps
select date_format(current_date, '%e %m %Y')

where you can manage how your date looks like

 

[sts8500man]

Does this work with MS Access for getting the system date?

 

[r937]

no

in microsoft access, you actually have to select from some table in your SELECT statement

rudy

http://r937.com/

SQL Consulting

 

[sleipnir214]

Actually, yes you can.

In Access, you can create an SQL pass-through query which passes the query directly to the database server.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[KarveR]

hey guys, don't forget curdate() !

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.