Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    14

    Cool Unanswered: How to convert datetime file to char in SYBASE

    Dear all,

    Is there any way that I can use the CONVERT function to convert a datetime datatype to char with perdefined format.

    In Oracle I can use:

    select to_char(createtime,'YYYY/MM/DD HH24:MIS') from XX;

    Can I do the same in Sybase.

    Thanks in advance

  2. #2
    Join Date
    May 2004
    Posts
    5
    Yes, to many different formats using the convert function. See the manual and if you dont have it you can read it online at Sybase.com.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •