4. Understanding the Elements of SQL Statements : SQL Operations : Assignment Operations : Ingresdate Assignments
 
Share this page                  
Ingresdate Assignments
The ingresdate data type is compatible with string data types if the value in the string is a valid representation of a date or time input format.
Absolute date or interval column values can be assigned to an ingresdate column. In addition, a string literal, a character string host variable, or a character string column value can be assigned to an ingresdate column if its value conforms to the valid input formats for Ingres dates or times.
When a date value is assigned to a character string, the DBMS Server converts the date to the display format (see How Ingres Dates and Times Are Displayed).