Just another Perl shrine | |
PerlMonks |
Comparing timestamps that are in 2 different but defined stylesby technojosh (Priest) |
on Jul 23, 2010 at 20:03 UTC ( [id://851089]=perlquestion: print w/replies, xml ) | Need Help?? |
technojosh has asked for the wisdom of the Perl Monks concerning the following question:
I have the following problem, and I've put *a little* thought and search into the solution but nothing is smacking me in the face just yet: I maintain an automated test tool that validates a web app sitting on a MSSQL db. We have added a set of 'audit' tables to our MSSQL database, and these tables all have 'DateTime' columns, which give dates in the format: 2010-07-23 19:44:43.523 I need to compare that date with Perl's localtime(time) value, and decide if this stamp is within ~1 minute of the value stored in the database. FYI: on my system (windows7), localtime(time) returns the following format:
Back to
Seekers of Perl Wisdom
|
|