Re: New user needs help with dates in a table

On Thu, 06 Mar 1997 18:16:13 -0500, Charlie Davies <cdavies@harris.com> wrote: >I'm new to databases and Informix. Could someone please tell me the >correct format for inserting a date into a table. > >I want to put the date and time (03/01/1997 13:10:24) into a table. > >What should the data type be, and how should the table declaration look? > >If I was to import the date(s) from a file, what should the file look >like? > >Thanks in advance for helping a newbie. > {Snip} It looks like you want to use DATETIME YEAR TO SECOND from your example. The (raw) data should be formatted "1997-01-01 12:00:00". The quote are necessary since there is a space between day and hour. Hope this helps. Chris Burton cburton@gte.net