Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: VBQ (very basic question) date

Re: VBQ (very basic question) date

From: Gennady <gennadyb_at_halcosoftware.com>
Date: Thu, 24 Jun 1999 09:28:00 -0700
Message-ID: <37725a57$0$18948@fountain.mindlink.net>


Hello, Marcus:
You have two options:
1. ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; 2.Change at Registry ( or create new)

   HKEY_LOCAL_MACHINE/Software/Oracle/NLS_DATE_FORMAT    Add string value then modify, set this name to value: DD-MON-YYYY HH24:MI:SS

   Then reboot.

Gennady

bernd1615_at_my-deja.com wrote in message <7ktgj1$7qv$1_at_nnrp1.deja.com>...
>Dear Participants ,
>
>I have some trouble setting the date format:
>
>create table some_table
>( ...
> dat date,
> ... )
>
>I don`t want to take the default date format but something like :
>
> ...
> dat date (DD MON YYYY HH24 MI SS) ,
> ...
>Does someone of you know the correct syntax for that ?
>
>Your insight knowledge will be greatly appreciated !
>
>Markus Banach
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jun 24 1999 - 11:28:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US