Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2014
    Posts
    2

    Unanswered: Wrong representation of Year Data in a table

    Hi,

    I have a sybase data table, which contain year column. when i queried the data, the year values are shown by containing comma in it. It is not for all the rows. It is only for selected records here and there. This is quite surprising for me.
    The year is defined as Integer with precision 10 and length of 4.
    I don't understand why this occurs. Please help!.

    I have attached the screenshot of sample data for your reference.

    Thanks in advance for your help.
    Green Lantern
    Attached Thumbnails Attached Thumbnails Sample Data.jpg  

  2. #2
    Join Date
    Feb 2012
    Posts
    133
    what is the datatype of your YEAR column?

  3. #3
    Join Date
    Nov 2014
    Posts
    2

    Wrong representation of Year Data in a table

    Column Name: Year
    Data Type: Integer
    Precision: 10
    Length: 4

  4. #4
    Join Date
    Feb 2012
    Posts
    133
    are you sure that you have correct datatype on Year column? you can store data value for INT type on a exact numeric value only. precision deals more on numeric decimal, float,etc.

Posting Permissions

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