Can anyone convert this Oracle sql to MySQL?

dayneo · #1 (**permalink**) 02-13-07, 03:39

Hi guys and gals,

I am doing some integration from Oracle to MySQL and need to know the quivelent MySQL sql for the following Oracle sql:

Code:

select trunc(sysdate) from dual

Basically selecting the current system date without the time part (ie. 13/02/2007).

Thanks

shammat · #2 (**permalink**) 02-13-07, 04:42

What's wrong with

Code:

SELECT CURDATE()

See: Date and Time Functions

dayneo · #3 (**permalink**) 02-13-07, 05:18

That simple hey

... I feel like a real idiot.
Thanks!

r937 · #4 (**permalink**) 02-13-07, 07:39

actually CURRENT_DATE would be better, since it's standard sql

(you will be less likely to need to change it again if you switch database systems once more)

Internet Services

Web Development

Digital Marketing

Consumer Tech