Home » RDBMS Server » Server Utilities » How to load in a constant date with sqlloader ?
How to load in a constant date with sqlloader ? [message #368069] Fri, 18 February 2000 08:45 Go to next message
arjan
Messages: 6
Registered: September 1999
Junior Member
I use the following syntax :
datefield constant "01-jan-00"
that works fine but i want to insert a date like
01012000 (ddmmyyyy) cause i dont want to insert 01011900 instead of 01012000.
Does anyone have a suggestion ?
Please Email me

greetings

arjan

Report message to a moderator

Re: How to load in a constant date with sqlloader ? [message #368070 is a reply to message #368069] Mon, 28 February 2000 04:36 Go to previous message
US
Messages: 1
Registered: February 2000
Junior Member
when U are simply loading the data using the loader the date will automatically be preffixed with 20

Report message to a moderator

Previous Topic: Re: Regarding date format thru SQL Loader
Next Topic: Re: Access to Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 22:11:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.