Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    27

    Unanswered: Store time data as 24 hours format

    Hi, i'm using oracle 8i and i'm wondering how to keep the time data as 24hours format in a date data type...

    I'm using asp to do the insertion...Please help...

    i know i can do something like this :

    TO_DATE ( '7:30' , 'HH:MI')

    but this is not in 24hours format...how can i achieve that?

    one more thing, if i use the TO_DATE function, i get this in the database:

    4/1/2004 7:30:00 AM

    how can i do without the date??
    Warm Regards,
    Jacky

  2. #2
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    you need the mask 'HH24:MI'

    you can't store just a time in a date field, when you select it you would to_char(date_field,'HH24:MI')
    There are 10 types of people in the world, those that know Binary and those that don't.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •