Home » Developer & Programmer » Forms » list item for a date column (oracle 10g)
list item for a date column [message #327791] Tue, 17 June 2008 11:42 Go to next message
vinodkumarn
Messages: 54
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

Re: list item for a date column [message #337087 is a reply to message #327791] Tue, 29 July 2008 21:21 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

Did you try using "to_date('07/01/2008','DD/MM/YYYY')"?

David
Re: list item for a date column [message #338043 is a reply to message #337087] Sat, 02 August 2008 13:42 Go to previous message
vinodkumarn
Messages: 54
Registered: March 2005
Member
hi david,

sorry for getting back to you so late, i was not logging lately
my requirement got changed and that was solved


thanks

[Updated on: Sat, 02 August 2008 13:44]

Report message to a moderator

Previous Topic: Oracle qo g application with web
Next Topic: The form hangs!
Goto Forum:
  


Current Time: Sat Dec 10 14:43:27 CST 2016

Total time taken to generate the page: 0.06565 seconds