Is there a isdate function?

dbatlanta · #1 (**permalink**) 12-12-05, 13:56

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

gurey · #2 (**permalink**) 12-13-05, 06:51

Hi,

Please, define environment variable DBDATE=Y4MD

Gustavo.

ravi_pentakota · #3 (**permalink**) 12-13-05, 07:43

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

Internet Services

Web Development

Digital Marketing

Consumer Tech