![]() |
SQL-J Language Reference
|
Reference Manual |
TIMETIME provides for storage of an hour-minutes-seconds-fractional-seconds value with six digits in the fractional-seconds part. Syntax for Column DefinitionCorresponding Compile-Time Java TypeJDBC Metadata Type (java.sql.Types)Dates, times, and timestamps cannot be mixed with one another in expressions except with a CAST. SQL-J is more permissive than SQL-92 in the values and formats it permits in date/time literals. Any value that is recognized by the java.sql.Date, java.sql.Time, or java.sql.Timestamp valueOf(String) method is permitted in a column of the corresponding SQL-J date/time data type. Literal SyntaxTIME Literal ExamplesTIME'15:09:02' '15:09:02' |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |