comment on

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:
1 - Storing of the application and time range values (retain simple human editability).
2 - How to gather such data (although, I suspect I can write some ugly SQL statement).

Anybody have thoughts on how to approach this?

Thanks

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.

-- philip
We put the 'K' in kwality!

In reply to Date/Time Parse with time exemptions and SQL querying by guice

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Perl Monk, Perl Meditation
	PerlMonks