| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
