Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Thanks,

Praveen

Tags:
Not what you were looking for? View more on this topic or Ask a question