To get the date portion only from get dates try the following
select CONVERT(VARCHAR(5),GETDATE(),114)
this can then be used to see if a time has passed
CONVERT(VARCHAR(5),GETDATE(),114)>'15:00'
Subscribe to:
Post Comments (Atom)
Multi Point USB Charger
USB Plug Charger, 4-Port USB Fast Charger Plug with 33W Intelligent Quick Charge 3.0 Wall Charger, Multi USBPower Adapter UK Fast Charging...
-
If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro... -
Today, emergencies happen often. Below is a list of emergency supplies that you should have available. This list is not made in stone. For...
-
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
No comments:
Post a Comment