Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    8

    Question Unanswered: Data Conversion in Sybase

    I am trying to convert datetime field to varchar and print.
    I am gettin below error
    "implicit conversion of VARCHAR value to a DATETIME field in Sybase"

    How to resolve it
    plz help me
    '

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Did you do something like this (which should work):

    Code:
    declare @v varchar(30)
    
    select @v = convert(varchar, date_value);
    If not, could you please post the actual code that causes the error?

    Michael

  3. #3
    Join Date
    Sep 2006
    Posts
    8
    yaa,
    My problem is solved .

    Thanks

Posting Permissions

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