Home » Developer & Programmer » Forms » Date conversion problem
Date conversion problem [message #84167] Mon, 09 February 2004 07:57 Go to next message
Stef
Messages: 8
Registered: April 2003
Junior Member
I'm working with Oracle Forms 6.0.8.14.1.

I've got a VARCHAR2(4) column in a table, in which I store a time indication, such as 0800, 2000, 1830 and so on.

I want to load it in a DATE form field, which has the format mask = 'HH24:MI'.

I valorize it in the post-query trigger with the code:

:MAIN.DATE_FIELD := TO_DATE(DATABASE_COLUMN, 'HH24MI');

But all I get is '00:00', also when a TO_CHAR message of the date returns me correct HH24 MI information.

Why?

Report message to a moderator

Re: Date conversion problem [message #84175 is a reply to message #84167] Tue, 10 February 2004 01:28 Go to previous messageGo to next message
Stef
Messages: 8
Registered: April 2003
Junior Member
Whoa. Solved. :)

Report message to a moderator

Re: Date conversion problem [message #84725 is a reply to message #84167] Wed, 21 April 2004 01:35 Go to previous message
Jaya
Messages: 8
Registered: May 2001
Junior Member
how did it get solved.Im having the same issue

Report message to a moderator

Previous Topic: problem in time format in format mask
Next Topic: PDE-PLI001
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 23:37:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.