Re: table definitions

Walter It signifies the precision, ie the datetime value will be stored as YYYY-MM-DD HH:MM:SS. HTH Sujit Walter T Rejuney <BlueSax@Unforgetable.com> on 01/24/2001 12:05:57 PM Please respond to Walter T Rejuney <BlueSax@Unforgetable.com> To: informix-list@iiug.org cc: Subject: table definitions I am an Oracle DBA trying to port an Informix application to Oracle and I've come across something in a table definition that I'm not sure about. In the table creation script there is a column defined like this: creation_timestamp datetime year to second yes Now, I can figure out that the name of the column is "creation_timestamp" and that the data type of the colum is "datetime" and that the "yes" means that nulls are allowed - but what does the "year to second" do? Does it provide a default value to the column?