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
This is a good reference for someone who wants to be a library designer. I see that the original website of article ( here ) is no longer be...
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 ...
Ubuntu Tips: Startup Application - Case study enabling touchpad edge scrolling and two fingers scrollingToday, I want to share a really handy feature in Ubuntu, Startup Application . Startup Application allows you to run additional script or pr...
After fresh install Ubuntu I found that sometimes my mouse cursor is missing and flickering so much. In order to solve this problem we need ...