|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: OKay Tiger [message #279387 is a reply to message #279322] |
Thu, 08 November 2007 01:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/43055.jpg) |
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
Forms 6i does not support the TIMESTAMP data type. My Forms 10g does - partially that is. I created a small form with
- a control block
- an exit button (exit_form(NO_VALIDATE) in the when-button-pressed)
- a text item (data type CHAR, length 60)
- a when-new-form-instance trigger:
Begin
:Control.Time_Stamp := TO_CHAR(SYSTIMESTAMP,'DD-MON-YYYY HH24:MI:SSxFF TZH:TZM');
End;
When I run it, it looks like this:
![/forum/fa/3370/0/](/forum/fa/3370/0/)
I've read on several forums that timestamps can still cause problems, but I haven't verified that. I suggest you do your own casting like I did.
A final note: I never used timestamp in Forms. It is mostly used on the database side.
MHE
PS: could you stop using these fancy colors and fonts? It's a bit messy.
[Updated on: Thu, 08 November 2007 01:09] Report message to a moderator
|
|
|