Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106

    Unanswered: date and time format

    I have a date field that I would like to format to display as military time without the ':' between the hours and the minutes in a varchar2 field. I have this statement for now (to_char(table.datefield,'hh24:mi') time_field)

    this one formats the date to be 17:05 fro example.

    I would like to have it display as 1705.

    Please help.

    Thanks
    Mo

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: date and time format

    Originally posted by mkasem
    I have a date field that I would like to format to display as military time without the ':' between the hours and the minutes in a varchar2 field. I have this statement for now (to_char(table.datefield,'hh24:mi') time_field)

    this one formats the date to be 17:05 fro example.

    I would like to have it display as 1705.

    Please help.

    Thanks
    ]
    (to_char(table.datefield,'hh24mi') time_field)

    Simple as that!

  3. #3
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106
    Thank you, that worked great.
    Mo

Posting Permissions

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