Home » Developer & Programmer » Forms » urgent: how to pass datetime type from form to form
urgent: how to pass datetime type from form to form [message #82395] Fri, 23 May 2003 14:08 Go to next message
SA
Messages: 37
Registered: March 2002
Member
Hi,

I need to pass a datetime type data from one form to the other using call_form. I used parameter list, but the parameter only has date type (I'm using 6i, the help says it has datetime type for parameter, but the drop down for parameter data type only has date, char, number to choose). I also tried :global, but it only got date passed. Could someone help me with this? Thank you very much!

Sa
Re: urgent: how to pass datetime type from form to form [message #82396 is a reply to message #82395] Fri, 23 May 2003 20:27 Go to previous message
ash
Messages: 43
Registered: February 2001
Member
Hi, pls try to employ this algo in your code..
to pre-assign a datetime datatype to a global var:

SELECT TO_CHAR(Date_Created,'DD-MON-YYYY HH24:MI:SS')
INTO :Global.MyDate FROM Your_Table;
Previous Topic: ORA-00600: internal error code, arguments: [12700], [25019], [67115126], [45]
Next Topic: Everytime i face the same with MDR
Goto Forum:
  


Current Time: Fri Mar 29 04:20:56 CDT 2024