Re: Oracle Date fields and perl

by arturo (Vicar)

on Mar 05, 2003 at 20:36 UTC ( #240694=note: print w/replies, xml )

Need Help??

I would use Oracle's built-in to_date(datestring, formatstring) function, e.g.:

   UPDATE table SET date_field = to_date(?, 'YYYYMMDDHH24MISS')
   WHERE id = ?
[download]

, assuming of course that by "hh" you mean 24-hour.

If not P, what? Q maybe?
"Sidney Morgenbesser"

Comment on Re: Oracle Date fields and perl Select or Download Code

Replies are listed 'Best First'.
Re: Re: Oracle Date fields and perl by abhishes (Friar) on Mar 05, 2003 at 22:28 UTC
that works! thank you.	[reply]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://240694]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others having an uproarious good time at the Monastery: (1)

As of 2023-06-08 04:12 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?