Comparing timestamps that are in 2 different but defined stylesby technojosh (Priest)
|on Jul 23, 2010 at 20:03 UTC||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:
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: