Re: How to set DATETIME ENV variable???

T.Suresh Kumar wrote: > > Hello > I need to set a DATETIME format for HPL to load data into Informix > database. > I have 2 date fields one with type DATE and another with type > DATETIME. > I set environment variable export DBDATE=DMY4- for DATE field > type > how to set for DATETIME that the date is of format DD-MM-YYYY > HH:MM:SS ? > I should be able to set it globally like DBDATE. > Is there any variable available like this?? I do not think that you can do this. You could download my date handling functions from the IIUG Software Repository and use it to reformat the input datetime strings to an acceptable format (ie YYYY-MM-DD HH:MM:SS). My getdate() function understands JUST ABOUT anything you can throw at it, even something as esotheric as "3 hours after yesterday". However, as is it does not handle your format but one could add it easily if one is even marginally familiar with YACC/Bison. Art S. Kagel