Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date question
Message
From
02/09/1999 10:02:53
 
 
To
27/08/1999 17:09:47
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00257848
Message ID:
00260576
Views:
18
>> What's the best way to get the "date part" of a GetTime() value?

That's a really good question what about something like this:

convert(datetime, convert(varchar(11), getdate(), 102))

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform