Skip to main content

Formating date and times in T-SQL is not as hard as I originally thought

MySQL has some great date formatting features that I missed in T-SQL.

Turns out, T-SQL has some nice features too.

SELECT FORMAT( @d, 'dd/MM/yyyy', 'en-US' ) AS 'DateTime Result'

See https://msdn.microsoft.com/en-AU/library/hh213505.aspx 






































Comments











Post a Comment



















Popular posts from this blog




















NMAP




























It's been about 15 years since I used NMAP, I forgot how useful the tool is.   To find out what services are running on an IP address simply use something like   nmap -n -v -p1-10000 x.x.x.x   -n tells nmap not to do name resolution (saves about 13 seconds if the IP you're scanning isn't in DNS_  -v verbose  -p1-10000 says scan ports 1 to 10,000 (otherwise nmap will only scan the first 1000 ports) 




















Post a Comment









Read more