Informix to Sybase convertion, Extend function(informix) equalent in sybase


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Thread: Informix to Sybase convertion, Extend function(informix) equalent in sybase

  1. #1
    Join Date
    Jun 2004
    Posts
    1

    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 .

    99-07-01 08:45:01.00010
    YEAR-MONTH-DATE HOURS:MINUTES:SECOND.MICROSECONDS

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center