OraFAQ Forum: Forms » date format as timestamp

Home » Developer & Programmer » Forms » date format as timestamp

Thu, 11 September 2014 06:56

Mayur Shinde
Messages: 60
Registered: August 2014
Location: Pune, Maharashtra

Member

Hi,
I have to save date as timestamp into database.
I declare one global variable as :

               :global.crdt        := sysdate;

I am using below mentioned code:

    INSERT INTO TRANSACTIONS_MST(CR_BY)VALUES (:GLOBAL.CRDT);

But when I run below mentioned query:

         SELECT cr_dt FROM TRANSACTIONS_MST;

OUTPUT is: 9/11/2014 12:00:00 AM

But I want output as exact date and time.

Please suggest solution.

Thu, 11 September 2014 07:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why don't you, then,

INSERT INTO TRANSACTIONS_MST (CR_BY) VALUES (sysdate);

Thu, 11 September 2014 07:28

Mayur Shinde
Messages: 60
Registered: August 2014
Location: Pune, Maharashtra

Member

Thank you.

Previous Topic:	Clear Item After Changing Items from List Item
Next Topic:	Oracl Form 10g Graph issue

Goto Forum:

]

Current Time: Sat Feb 08 19:49:47 CST 2025