Re: Help Loading YYYYMMDD Dates

From: Roy Wagner <roywagner_at_aol.com>
Date: 1995/05/22
Message-ID: <3pqmgg$ba9_at_newsbf02.news.aol.com>#1/1

I thank everyone who has offered solutions to my problem. Two Oracle
"gurus" have sent me the same and quite simple answer that I was hoping
was out there. Here it is:

INTO TABLE testdate
(date POSITION(1:8) "TO_DATE(REPLACE(:date, ' ', '0'), 'YYYYMMDD')")

Again thanks for the help!

Roy Wagner -
"When driving my Miata, I always get to where I'm going before I want to
stop driving it."

Received on Mon May 22 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Mark Citron: "Re: Where to find average salaries of Oracle programmers?"
Previous message: Scott Urman: "Re: How to logout in PRO*C?"
In reply to: Blv n Drms: "Re: Help Loading YYYYMMDD Dates"
Next in thread: surya_at_usa.net: "Re: Where to find average salaries of Oracle programmers?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message