On 2006-10-18 10:19:24 -0400, Hardy Merrill wrote:
I think I get it yes. So here is what I am doing. Access has a date
field that I am pulling out and when I print the $start_date variable
it looks like this:
2006-09-15 00:00:00
That is a string now to Perl...correct? Now I am inserted
Peter J. Holzer wrote:
On 2006-10-18 10:19:24 -0400, Hardy Merrill wrote:
I think I get it yes. So here is what I am doing. Access has a date
field that I am pulling out and when I print the $start_date variable
it looks like this:
2006-09-15 00:00:00
That is a string now to Perl...correct?
Sorry for the top-post - Groupwise :-(
Notice how Philip suggested using to_char - *not*
to_date.
You probably already know this, but on the chance you don't,
you use to_date if you have a string that contains a date and
you want to put that date into a DATE column in the database.
You use
Robert Hicks wrote:
Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Any gotchas there? I am opening an Access db via ODBC and binding
those columns (including a date field) and passing that to the
Oracle handle to do inserts (i.e. Access - Oracle migration).
Only gotcha is with
Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Hardy Merrill wrote:
Sorry for the top-post - Groupwise :-(
Notice how Philip suggested using to_char - *not* to_date.
You probably already know this, but on the chance you don't,
you use to_date if you have a string that contains a
Any gotchas there? I am opening an Access db via ODBC and binding those
columns (including a date field) and passing that to the Oracle handle
to do inserts (i.e. Access - Oracle migration).
Robert
Robert Hicks wrote:
Any gotchas there? I am opening an Access db via ODBC and binding
those columns (including a date field) and passing that to the Oracle
handle to do inserts (i.e. Access - Oracle migration).
Only gotcha is with formatting -- you'll need to either:
1) alter session set
Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Any gotchas there? I am opening an Access db via ODBC and binding
those columns (including a date field) and passing that to the Oracle
handle to do inserts (i.e. Access - Oracle migration).
Only gotcha is with formatting -- you'll
