Home » Open Source » MySQL » Date Prob In MySQL (MySQl 5.0)
Date Prob In MySQL [message #504854] Thu, 28 April 2011 02:38
oraarvind
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.
Bhujang

[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: Tue Mar 19 04:53:38 CDT 2024