Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    11

    Unanswered: Is there a isdate function?

    Hi all:

    I am new to Informix. Is there a isdate function in Informix. What I am trying to do is I have a table with 20 milliion rows. One of the column is 'DATE'. I have to make sure that the date column has actual date in it in the "yyyymmdd" format. If the date field is in the "yyyymmdd" format I should get true otherwise false. Can anyone please help me.

    Thank you in advance

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    Please, define environment variable DBDATE=Y4MD

    Gustavo.

  3. #3
    Join Date
    Dec 2005
    Posts
    8
    Quote Originally Posted by dbatlanta
    Hi all:

    I am new to Informix. Is there a isdate function in Informix. What I am trying to do is I have a table with 20 milliion rows. One of the column is 'DATE'. I have to make sure that the date column has actual date in it in the "yyyymmdd" format. If the date field is in the "yyyymmdd" format I should get true otherwise false. Can anyone please help me.

    Thank you in advance
    in informix date function is there.but it is to be used for ur field is date time u want to extract only date then u can use date(ur col name).but in this case u can check u r data type & default format for date.

    regards
    ravipentakota1@yahoo.co.in

Posting Permissions

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