Informix to Sybase migration, Extend function(informix) equalent in sybase
We are migrating from informix to sybase and i need to convert the informix query to sybase . I have problem here , the informix query as follows
SELECT extend(beg_time, year to fraction(5)),
extend(end_time, year to fraction(5)) FROM TABLE_XXXX .
this query will give the timestamp with microseconds . So i need to convert this to sybase . Is there any function in sybase to get the timestamp with the microseconds .
The results from informix query is coming like this and i need to write a query in sybase get the results like this .
Is there any function or some thing to get the timestamp like this in SQL query in sybase
I would appriciate your help .
Thanks in advance
Last edited by Kavitha; 06-21-2004 at 02:34 AM.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center