http://in.compucrete.com/index.php?action=history&feed=atom&title=Time_Queries_for_Tickets_and_Sales_History 2026-05-15T15:29:24Z Revision history for this page on the wiki MediaWiki 1.40.0 http://in.compucrete.com/index.php?title=Time_Queries_for_Tickets_and_Sales_History&diff=662&oldid=prev 2023-07-14T13:00:38Z

<p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:00, 14 July 2023</td> </tr> <!-- diff cache key my_wiki:diff::1.12:old-661:rev-662 --> </table>

WikiAdmin http://in.compucrete.com/index.php?title=Time_Queries_for_Tickets_and_Sales_History&diff=661&oldid=prev 2017-01-10T00:02:25Z

<p>1 revision imported</p> <p><b>New page</b></p><div>Converting a Date and Time (HHMM) into a time stamp:<br /> <br /> &lt;PRE&gt;<br /> select ticket_date,ticket_time,<br /> ticket_time/100 &quot;Hour&quot;,<br /> ticket_time-100*(ticket_time/100) &quot;Minute&quot;,<br /> 60*(ticket_time/100)+ticket_time-100*(ticket_time/100) &quot;Minutes&quot;,<br /> cast ( (60*(ticket_time/100)+ticket_time-100*(ticket_time/100)) as numeric (11,6) ) /1440 &quot;Frac day&quot;,<br /> cast(ticket_Date as timestamp )+cast ( (60*(ticket_time/100)+ticket_time-100*(ticket_time/100)) as numeric<br /> (11,6) ) /1440 &quot;Ticket Timestamp&quot;,<br /> floor(1440*(Return_Plant_DT-cast(ticket_Date as timestamp )-cast ( (60*(ticket_time/100)+ticket_time-100* <br /> (ticket_time/100)) as numeric (11,6) ) /1440) ) &quot;Elapsed Minutes &quot;<br /> from artslshd<br /> where ticket_date = '3/31/08'<br /> &lt;/PRE&gt;</div>

Intra>User