Date Prob In MySQL [message #504854] |
Thu, 28 April 2011 02:38 |
![](http://www.gravatar.com/avatar/eb0a3d9c523ea548a371b3626c7a6b0b?s=64&d=mm&r=g) |
oraarvind
Messages: 2 Registered: March 2011 Location: India
|
Junior Member |
![arvindkumarbhujang@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
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
|
|
|