Home » Developer & Programmer » Forms » how to extract the time value from date field and store the same in another date field?
icon5.gif  how to extract the time value from date field and store the same in another date field? [message #189928] Mon, 28 August 2006 11:12 Go to next message
fazal_haq2001
Messages: 35
Registered: July 2006
Location: India
Member
Hi,
I m trying to extract the Date field with time value and store the same value in the another date field..
But the date only stored...
So plz guide THAT , How to Store the date with time field in the date field through forms 6i..

EX:
select to_char(starttime,'ddmmrrrr hh24:mi:ss') into st_time
from xyz;
this retrieves the date with time..

But i cant able to store the same through the forms 6i date variable..
Re: how to extract the time value from date field and store the same in another date field? [message #189965 is a reply to message #189928] Mon, 28 August 2006 14:12 Go to previous messageGo to next message
rampratap
Messages: 50
Registered: November 2004
Location: New Delhi
Member

Hi,

In form 6i u should make Format mask for the date filed as required


open the form in object navigator
select the date field and press F4
there u can set this property
Re: how to extract the time value from date field and store the same in another date field? [message #189995 is a reply to message #189928] Tue, 29 August 2006 00:07 Go to previous message
sameer_am2002
Messages: 129
Registered: September 2002
Senior Member
Set the datatype of form field to datetime.
Previous Topic: menu toolbar not visible on form
Next Topic: navigation in tabular form must stop at last record
Goto Forum:
  


Current Time: Mon Dec 05 15:21:47 CST 2016

Total time taken to generate the page: 0.16921 seconds