Fetching some values on the basis of timestamp values
Hi SAP experts,
I am using SAP MII 12.2.
We have ABB SCADA VANTAGE through which we have connected our SAP MII through Plant connector PCo.
In the SCADA table there are columns like name,value,timestamp and UOM.
Now i need to write a select query to fetch values on the basis of timestamp values.
The time stamp field has values in the format like '08/08/2013 12:23:00'.
What my requirement is to fetch values for 24 hours duration between 06:00:00 to 06:00:00 that is between 6 am on one day to 6 am on the next day.
I am not getting how to frame a SELECT query to achieve this that is how to compare the timestamps.
I am using BETWEEN command but its giving error as we cant comapre the date and time togather,I think some conversion needs to be done.
Any help on this would be highly appreciated.