Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    10

    Unanswered: Date Time Format

    Hello!

    I want to ask if there is a 24Hour format in the SQL?

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

    Re: Date Time Format

    The answer depends on your DBMS. I know for Oracle the answer is yes:

    SELECT TO_CHAR(SYSDATE,'HH24:MIS') FROM DUAL;

  3. #3
    Join Date
    Jan 2004
    Posts
    10
    Thanks for the reply sir, but I want it already formatted in the database itself. Like for example in Microsoft Access, there is a selection of format which I can choose. e.g. "Short Date", "Long Time" etc..

Posting Permissions

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