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