Convert Datetime

[inaranjo]

Hi,

Does any one know how to obtain a date format "Mon dd yyyy hh:miAM" from "yyyy-mm-dd" adding the seconds?
In Oracle I can use the following:

select to_char(to_date('2004-09-30','yyyy-mm-dd hh24:mi:ss')+(86346/86400),'Mon dd yyyy hh24:mi:ss') from dual

Being 2004-09-30 the date and 96346 the seconds to obtain: "Sep 30 2004 23:59:06"

Thanks in advance,
Ivonne

 

[inaranjo]

Sorry,

Im using Sybase 12.0

 

[scriptdan]

Assuming the field is a datetime

select convert(char(17),YourDatetimeHere,109)+substring(convert(char(26),YourDatetimeHere109),25,2)