1 Replies - 5832 Views - Last Post: 16 September 2009 - 12:28 AM Rate Topic: -----

#1 Guest_NIXZ*


Reputation:

SELECT CURDATE() FROM Dual | Time in specific format DD/MM/YYYY

Posted 15 September 2009 - 02:12 PM

SELECT CURDATE() FROM Dual

What's the command to get the date in DD/MM/YYYY Format ???
I need it so i could know what are the days/months/years cause in
some countries e.g. where i live its DD/MM/YYYY while in UK its MM/DD/YYYY

This post has been edited by NIXZ: 15 September 2009 - 02:14 PM

Is This A Good Question/Topic? 0

Replies To: SELECT CURDATE() FROM Dual | Time in specific format DD/MM/YYYY

#2 motcom   User is offline

  • D.I.C Lover
  • member icon

Reputation: 293
  • View blog
  • Posts: 1,371
  • Joined: 16-June 08

Re: SELECT CURDATE() FROM Dual | Time in specific format DD/MM/YYYY

Posted 16 September 2009 - 12:28 AM

Hey NIXS

I presume its MySQL..

Have a look at their date time functions at

http://dev.mysql.com...-functions.html
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1