Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    24

    Unanswered: convert char to datetime

    Hi,

    I have a record with char as datatype in sybase. I want to convert it to datatime datatype. eg.
    the value as char is 1992Q1 to be converted as 19920331
    and for 1992Q2 as 19920630
    for 1992Q3 as 19920930, for 1992Q4 as 19921231

    If any one can send me the update statement for this that will be appreciated.
    Thanks
    Srinivas chityala

  2. #2
    Join Date
    Feb 2004
    Posts
    24

    Re: convert char to datetime

    Originally posted by oracle08821
    Hi,

    I have a record with char as datatype in sybase. I want to convert it to datatime datatype. eg.
    the value as char is 1992Q1 where Q1 is first quarter to be converted as 19920331 (march 31)
    and for 1992Q2 where Q2 is second quarter as 19920630 (June 30)
    for 1992Q3 as 19920930, for 1992Q4 as 19921231

    If any one can send me the update statement for this that will be appreciated.
    Thanks
    Srinivas chityala

Posting Permissions

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