Spearcross

All About Programming, Piece of My Mind, And Anything

Spearcross

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • About

Tag Archives: MSSQL

MSSQL Query Two Digit Year, Month, and Date

Posted on March 26, 2011 by silentcross
2

Here’s some SQL Query to get Two Digit Year, Month and Date

Year :

1
print right(year(getdate()), 2)

result :
11

Month :

1
print right('0' + month(getdate()), 2)

result :
03

Date :

1
print right('0' + day(getdate()), 2)

result :
26

Posted in Programming, Windows | Tagged MSSQL, SQL Query | 2 Replies

Recent Posts

  • DDNS Cloudflare API
  • Change Hosting in 2018
  • MTCNA + MTCRE Accomplished
  • OpenWRT + Dnscrypt On TP-Link WDR3600
  • ASP.NET Core RC2 To RTM

Categories

  • ASP.NET (2)
  • C (1)
  • Event (3)
  • FreeWare (2)
  • IIS (5)
  • Intro (1)
  • Linux (3)
  • News (2)
  • PHP (4)
  • Piece of My Mind (17)
  • Programming (15)
  • Uncategorized (7)
  • Windows (12)

Tags

  • .NET
  • ASP.NET
  • Cannot Print
  • Canon IP4870
  • Cloudflare
  • Computer
  • C Programming
  • DDR1
  • DDR2
  • Decimal
  • Eggdrop tcl script
  • Event
  • Festival Komputer Indonesia
  • FKI
  • Gateway
  • Hotmail
  • HTTPS
  • IIS 6
  • IIS ASP.NET
  • IndoComtech
  • Ink
  • Linux
  • Local Network
  • Memory
  • Microsoft
  • MRTG
  • MS SQL
  • MSSQL
  • PHP
  • PHP Windows IIS5
  • Proxy
  • Reset
  • Restter
  • Roman
  • SODIMM
  • SQL
  • SQL Query
  • Squid
  • T-SQL
  • Tank
  • uBuntu
  • Windows
  • Windows 7
  • Windows Server 2003
  • Wordpress

Calendar

December 2019
M T W T F S S
« May    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Blogroll

  • Cybernations
  • Kaskus
  • Namecheap
  • Support Forum
  • Themes
  • WordPress Blog
  • WordPress Planet

Tags

  • .NET
  • ASP.NET
  • Cannot Print
  • Canon IP4870
  • Cloudflare
  • Computer
  • C Programming
  • DDR1
  • DDR2
  • Decimal
  • Eggdrop tcl script
  • Event
  • Festival Komputer Indonesia
  • FKI
  • Gateway
  • Hotmail
  • HTTPS
  • IIS 6
  • IIS ASP.NET
  • IndoComtech
  • Ink
  • Linux
  • Local Network
  • Memory
  • Microsoft
  • MRTG
  • MS SQL
  • MSSQL
  • PHP
  • PHP Windows IIS5
  • Proxy
  • Reset
  • Restter
  • Roman
  • SODIMM
  • SQL
  • SQL Query
  • Squid
  • T-SQL
  • Tank
  • uBuntu
  • Windows
  • Windows 7
  • Windows Server 2003
  • Wordpress
Proudly powered by WordPress