Jan 19

Written by: Steve Gray
1/19/2010 3:15 PM 

Here’s a little function that can be quite helpful. It returns the current date in ‘YYYY-DD-MM’ format.

 

select {fn CURDATE()}

 

This is not SQL syntax, but it’s a part of the ODBC Scalar Functions