Thursday, December 16, 2010
SQL Tips : Converting SQL Server Date time format
This morning, one of my friend asked me "how to convert SQL Server DateTime format into other format?".
Example: from this 2010-12-17 (yyyy-mm-dd) format into 17-DES-2010 (dd-Mon-yyyy) format.
and here's my answer:
SELECT UPPER(REPLACE(CONVERT(VARCHAR(11), GETDATE(), 106), ' ', '-')) AS [DD-Mon-YYYY]
and its worked well
If you are tired of being asked for a password when accessing your remote droplet servers in Digitalocean, you might consider adding an rsa ...
This time, I've created a really simple text based game that allow the player to progress state to another state by choosing some option...
Long time no see. Installing CPNTools for Windows is easy, but today I have a problem when installing cpntools on a Windows Server 2008. Ac...
Hadoop Troubleshoot: Hadoop build error related to findbugs, Eclipse configuration, protobuf, and AvroRecordLast week, I was trying to build Hadoop 2.5.0 from source code. I tried several ways to build the source code, first one is using Maven in ...