TI Logbook

Java, Angular, Eclipse, PostgreSQL, SQL, Tips....

Wednesday, November 5, 2014

SQL Server: Current Date in SQL Server format yyyy-mm-dd

Current Date in SQL Server format yyyy-mm-dd

SELECT convert(varchar(30), cast(getdate() as date), 120) 

2014-11-05
Posted by Jose Velasquez at 7:34 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Labels

  • Angular (1)
  • Builder (1)
  • error TS2531 (1)
  • Form Builder (2)
  • hasError (1)
  • Lombok (1)
  • Maven (1)

Search This Blog

Blog Archive

  • ►  2022 (1)
    • ►  December (1)
  • ►  2021 (3)
    • ►  June (1)
    • ►  May (1)
    • ►  April (1)
  • ►  2019 (1)
    • ►  February (1)
  • ►  2018 (2)
    • ►  June (1)
    • ►  May (1)
  • ►  2017 (6)
    • ►  August (1)
    • ►  July (1)
    • ►  June (2)
    • ►  May (2)
  • ►  2016 (10)
    • ►  July (2)
    • ►  March (1)
    • ►  February (5)
    • ►  January (2)
  • ►  2015 (38)
    • ►  December (4)
    • ►  November (9)
    • ►  October (1)
    • ►  August (4)
    • ►  July (9)
    • ►  June (3)
    • ►  May (6)
    • ►  April (2)
  • ▼  2014 (12)
    • ▼  November (1)
      • SQL Server: Current Date in SQL Server format yyyy...
    • ►  October (3)
    • ►  September (4)
    • ►  August (4)
  • ►  2013 (2)
    • ►  September (1)
    • ►  May (1)
  • ►  2011 (4)
    • ►  January (4)
  • ►  2010 (2)
    • ►  December (1)
    • ►  October (1)

Total Pageviews

Simple theme. Powered by Blogger.