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
Brackets is an open source and free-to-use text editor and primarily being used by web developers and designer. I mainly use Brackets for d...
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 ...
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...