Re: time format always 12-hour format?

Hi, Frank.

        Oracle stores dates in its own format, but when you wish to view them, you can do...

select to_char(datefield,'MM/DD/YYYY HH24:MI:SS') from table

...to see the time represented in 24-hour format. You can set your NLS_DATE_FORMAT to this format mask if that's how you would like dates to appear when you select them without converting them, too.

HTH,
-Jeff

On Wed, 08 Dec 1999 19:31:32 +0100, f <frank.wehrle_at_mediaaktiv.de> wrote:

>Hi everyone,
>
>I am living and working in Germany and since here a 24 houre Time Format
>is usual I'd like to store times like "15:01:03".
>Now Oracle (I'm using 8.1.5i right now) always tells me hours have to be
>in between 1-12. I tried to find something in the doc, but I couldn't
>find anything. I got the feeling the NLS_DATE_FORMAT parameter should be
>capable of doing this, but I can not find an example or anything
>usefull.
>
>Sure I could use the AM PM thing, but (tell it beeing used to or
>whatever aou like) I think the 24-Hour format is way easier to work
>with!
>
>thanks in advance
>Frank
>
Received on Wed Dec 08 1999 - 20:16:23 CET