Need Help on Date issue!

aodat2 · #1 (**permalink**) 08-11-04, 10:28

Hi there!

I really need some help on the current date issue that I am having.

I created a field in MySQL under TEXT format and stored my date there (DD/MM/YYYY). I know it's stupid to do that, but I did it and didn't think of it at that time.

Anyway, currently I need to sort the dates and could not figure out a way to convert those dates into SQL readable format (YYYY-MM-DD). What can I do? Does anyone know how to convert a TEXT field (DD/MM/YYYY) to the SQL readable format?

I seriously need help. If anyone out there knows how to do it, please help me out. I'm extremely desprate here!

By the way, I am programming in PHP. Thank you for your help!

Worried Guy.

ealmiladi · #2 (**permalink**) 08-11-04, 11:41

Your going to have to redo your date system. There is no way to change that that I know, sorry.

r937 · #3 (**permalink**) 08-11-04, 19:08

Code:

select foo
     , bar
     , concat_ws('-'
        , substring(textdate,7,4)
        , substring(textdate,4,2)
        , substring(textdate,1,2)) as realdate
  from yourtable
order
    by realdate

Internet Services

Web Development

Digital Marketing

Consumer Tech