time stamp problem

[ransher]

hello, i made a code to read data from table using time stamp duration but the problem is that i am unable to read the desired result using time duration

For example: 2 hour on the date 25/07/2017 from the table

but i was unable to read it,the reason i found was that the time stamp i was getting to compare within the duration i have selected was not correct.

if anyone of you would sort it out that would be really grateful,thanks

[Gregory · Accepted solution]

Check your string that you make when you concatenate the date with the time, it looks like "25-07-201710:58". You need to add a space so it looks like this "25-07-2017 10:58". 

When you scan from string, your time is not exactly in the %T format, so you have to specify what your time looks like. Your format string will look something like this "%<%d-%m-%Y %H:%M>T".