Time Queries for Tickets and Sales History

From KeystoneIntranet
Jump to navigation Jump to search

Converting a Date and Time (HHMM) into a time stamp: 

select ticket_date,ticket_time,
  ticket_time/100 "Hour",
  ticket_time-100*(ticket_time/100) "Minute",
  60*(ticket_time/100)+ticket_time-100*(ticket_time/100) "Minutes",
  cast (  (60*(ticket_time/100)+ticket_time-100*(ticket_time/100))  as numeric (11,6) ) /1440  "Frac day",
  cast(ticket_Date as timestamp )+cast (  (60*(ticket_time/100)+ticket_time-100*(ticket_time/100))  as numeric
    (11,6) ) /1440  "Ticket Timestamp",
  floor(1440*(Return_Plant_DT-cast(ticket_Date as timestamp )-cast (  (60*(ticket_time/100)+ticket_time-100* 
    (ticket_time/100))  as numeric (11,6) ) /1440) ) "Elapsed Minutes "
from artslshd
where ticket_date = '3/31/08'
Retrieved from "http://in.compucrete.com/index.php?title=Time_Queries_for_Tickets_and_Sales_History&oldid=662"