Can anybody help l me how to extract hour, minutes and seconds from the various date and time formats.
In addition to this I have separate requiremnt about calculating the time 15 minutes before and display it in MMDDYYYYHHMMSS format. Basically the 15 minutes should be subtracted from the above format.
I idea is to retrieve the data from the SQL server the given time ranges in the above format. I will take care of writing the SQL. But I am stuch while subtracting 15 minutes from the format and display the time of 15 min ago in the message box.
Any help will be highly appreciated.