Sublimex Posted June 26, 2014 Share Posted June 26, 2014 Hi All, Im have a lot of fun with the SQL manager, it is so powerful. I am also familiar with T-SQL and creating SQL queries in MS Access but I cant for the life of me get my usual functions like format([datefield],'yyyy-mm-dd]) to work in sql manager. Two parts to this.. 1 does anyone know the simple solution to the above function and... 2 is there any documentation on the sql functions that can be used in sql manager? Cheers Matthew Sublimex.co.uk Sublimation Products for Sublimation Printers Link to comment Share on other sites More sharing options...
vekia Posted June 27, 2014 Share Posted June 27, 2014 mysql hasn't got format() command. instead of it use date_format more info here http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html Link to comment Share on other sites More sharing options...
Recommended Posts