Re: entering datetime values

Denise Wahl <wahl@uthscsa.edu> wrote: As far as I know, DATETIMEs are stored internally as DECIMAL with the length being determined by the number of fields specified. At least that's how it works in ESQL/C. I am assuming the engine uses the same storage. For example, March, 1997 as DATETIME YEAR TO MONTH is 199703. while March 5, 1997 as DATETIME YEAR TO DAY is 19970305. So, if you want the user to be able to omit the day, your program will have to add a default day. Hope this helps, Jeff Larsen larsen@qec.com >I have a column defined datetime YEAR TO DAY. I want the user to be >able to enter YEAR-MONTH if they don't have the DAY. > >I don't know if I'm missing something, but I can't seem to make this >work. Am I totally misunderstanding the function and use of DATETIME >fields? > >Thanks. > >Denise