Home » Developer & Programmer » Forms » date format as timestamp
date format as timestamp [message #623549] Thu, 11 September 2014 06:56 Go to next message
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.
Re: date format as timestamp [message #623550 is a reply to message #623549] Thu, 11 September 2014 07:00 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why don't you, then,
INSERT INTO TRANSACTIONS_MST (CR_BY) VALUES (sysdate);

Re: date format as timestamp [message #623556 is a reply to message #623550] Thu, 11 September 2014 07:28 Go to previous message
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: Thu Mar 28 09:20:22 CDT 2024