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
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
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 contai
Yes that looks correct.
If you're still having trouble with it, reply back and post
the small section of code that you're having trouble with,
and the error you are getting.
Hardy Merrill
>>> Robert Hicks <[EMAIL PROTECTED]> 10/18/2006 10:11 AM >>>
Hardy Merrill wrote:
> Sorry for the top-pos
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 date and
>> you wa
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 date and
you want to put that date into a "DATE" col
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
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
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 ne
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
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
11 matches
Mail list logo
