timestamp

[jeyasree]

how to select next highest timestamp from database than the given timestamp

i have tried so many datepart methods

plz

[abduraooft]

select myDate from myTable where myDate<givenDate order by myDate DESC LIMIT 1 ?

[jeyasree]

Thank you very much..

its working..
very useful to me :-)

[guelphdad]

what database application are you using? LIMIT is not standard. If you are using mysql then your question needs to be moved to the mysql forum. If using a different database application, then please specify in your thread title.