LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » max (time stamp) of A.M

max (time stamp) of A.M

Options

Previous Topic · Next Topic

mkaruna

Posted: Tuesday, July 06, 2010 12:38:14 PM

Rank: Newbie

Joined: 7/6/2010
Posts: 1
Points: 3

Hi,

How to get max date before next day A.M time, passing before day p.m time.

i.e for example we have following data date in dd/mm/yyyy format

06/07/2010 5:40 p.m
06/07/2010 8:00 p.m
07/07/2010 2:00 A.m
07/07/2010 3:00 A.M

if i send 06/07/2010 as input parameter i need to get
07/07/2010 3:00 A.M other wise null

Thanks

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.