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

Re: Convert date/Time string to date valid in an db import in MS Access

by aquarium (Curate)
on Aug 05, 2010 at 01:26 UTC ( [id://853003]=note: print w/replies, xml ) Need Help??


in reply to Convert date/Time string to date valid in an db import in MS Access

It's been a long time so can't remember the full details. In Access you can setup a import format file and use it through the import wizard in Access. Otherwise can't remember the default format but i'm sure Access Help lookup on import will help.
If you're going to do this on perl side, much better to use solid date/time module rather than writing own date/time functions, as there are a few gotchas, and the modules can work with many different formats for date/time.
Also noticed that Year is missing from the date. Unless you're absolutely and positively sure that you'll never need the year from the date, it should be there to start with. Assuming current year during import and other such things are likely to bite back.
the hardest line to type correctly is: stty erase ^H

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (7)
As of 2024-03-28 09:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found