Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a shorter syntax?
Message
From
23/05/2001 23:04:52
Andres Chiriboga
Visa International
Miami, Florida, United States
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Is there a shorter syntax?
Miscellaneous
Thread ID:
00510693
Message ID:
00510708
Views:
10
>>If you don't need two digit months ('4' vs. '04') you could use:
>
>I need the 04.

Then use the first example. 'mm' returns the month in two digit format.
Andres M. Chiriboga, MCSE, MCP+I
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform