Home » Open Source » MySQL » Date Prob In MySQL (MySQl 5.0)
Date Prob In MySQL [message #504854] Thu, 28 April 2011 02:38
Messages: 2
Registered: March 2011
Location: India
Junior Member

hi i am using following select statement in oracle.

Please tell me how to write same select statement in MySQL-5.0

select (case when df.date_format_id is not null then
to_char(SO.sales_order_date,DF.date_format) else to_char(SO.sales_order_date,`yyyy/mm/dd`) end) as SODate

from `SalesOrders` `SO`
left join DateFormats DF on....

Thanks in advance.

[Updated on: Thu, 28 April 2011 04:55]

Report message to a moderator

Previous Topic: View default values
Next Topic: Alter table from different databases
Goto Forum:

Current Time: Sat Dec 04 05:33:42 CST 2021