| list item for a date column [message #327791] |
Tue, 17 June 2008 11:42  |
vinodkumarn
Messages: 60
Registered: March 2005
|
Member |
|
|
Hello,
I need to have a list item(pop list)
it is based on a database column of DATE datatype
i need to show "July 1" as the display value and i should insert actual date "07/01/2008" as a date value.
i cannot have a DATE datatype column in the CREATE_GROUP_FROM_QUERY
also i cannot change the data type of the list item to DATE
when i have this as a query
select ''Jul 1'', ''07/01/2008" from dual
since ''07/01/2008" is a character, when i save i get the error "not a valid month"
so how to insert a DATE in the database, through a list item
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
