in reply to Not able to find dateTime value using sql
A little another hint: I think that it's not a bad idea to put your SQL queries into stored procedures wherever this is possible.
Then you can call the stored procedures via DBI and you don't need to worry anymore about formatting your SQL statements in perl - what often is an annoying task.
This is convenient and the performance will also be better.
Regards, Karl
«The Crux of the Biscuit is the Apostrophe»
|
|---|
In Section
Seekers of Perl Wisdom