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





















Javascript Form Validation




























It's real simple.   All you need to do is call a javascript function  in a html  " onsubmit " in the form tag as a javascript return, like this         <form method="post" action="dosomething.php" onsubmit="return validateForm();">    If the code completes ok, the form is then sent to the page listed in "action"   http://www.w3schools.com/js/js_form_validation.asp   If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.




















Post a Comment









Read more