Storing Time values?

Ranch Hand

Posts: 356

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,
It is good to see a new forum for Oracle. Here I go.. I have to store time values, I don't have a clue how to do it? Can anyone give some ideas?
Thanks,
Vanitha.

Raajesh Chandran

Ranch Hand

Posts: 103

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Vanitha,
For inserting time use Date Type
Ex:
insert into table1 values(To_Date('19/11/2001 2.50','DD/MM/YYYY HH:MT')

chandran..

Raajesh Chandran

Ranch Hand

Posts: 103

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Vanitha,
For inserting time use Date Type
Ex:
insert into table1 values(To_Date('19/11/2001 2.50','DD/MM/YYYY HH:MT')

chandran..

Opportunity is missed by most people because it is dressed in overalls and looks like work - Edison. Tiny ad:

Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop

https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton