Where clasue with julian date or convert julian date to date time
Posted on 2012-04-12
I have a user that need a report that pulls transactions between a certain time, say 0600 - 1600. The problem I have is that the date/time in the table is julian date. How can I select records just within those hours? Do I need to convert the julian date to date/time?
For example, here is one of the julian dates in the table: 2456020.5005
I would want to run a query similar to:
where juliandate between 0600 and 1600