Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Re: Computing Oracle date format from a date string

by Rhose (Priest)
on Aug 23, 2002 at 19:56 UTC ( #192427=note: print w/ replies, xml ) Need Help??


in reply to Re: Computing Oracle date format from a date string
in thread Computing Oracle date format from a date string

Yep, I threw together a quick script which might give you a starting point -- it should dump the dates out in 'YYYY-MM-DD HH24:MI:SS' format.

#!/usr/bin/perl -w use strict; $ENV{TZ} = 'EST5EDT'; use Date::Manip; my $gDate; while(<DATA>) { $gDate = ParseDate($_); print UnixDate($gDate,'%Y-%m-%d %H:%M:%S'),"\n"; } __DATA__ 2002-08-23 11:39:24.0 Fri Aug 23 12:14:04 2002

Update: Your timezone may be different. *Smiles*


Comment on Re: Re: Computing Oracle date format from a date string
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://192427]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (10)
As of 2015-07-07 06:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (87 votes), past polls