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 03:34 AM.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL