|Syntactic Confectionery Delight|
Date/Time Parse with time exemptions and SQL queryingby guice (Scribe)
|on Sep 02, 2005 at 15:42 UTC||Need Help??|
guice has asked for the wisdom of the Perl Monks concerning the following question:
I have a programming delima that I'm not sure how to approach this.
I have a SQL table with a number of number with application name and epoch time/date stored for each one. And I have an excel file saying "for X apps I need data for M-F 7am-8pm, Sat 8am-6pm, Sun 9am-1pm", etc. The times and dates can very with each application.
I'm trying to figure out what would be the best way to tackle this problem:
Anybody have thoughts on how to approach this?
Updated: Updated title. This isn't an excel thing; ingore the Excel peice. I'm not parsing an Excel document. They will be editing the date/time brackets per the format I give them.