• Tech
  • Forums
  • Jobs
  • Books
  • Events
  • Videos
  • Live
    • Interviews
    • Certification
    • Training
    • Career
    • Members
    • News
    • Blogs
  • An Article
  • A Blog
  • A Video
  • An Ebook
  • An Interview Question
  • Feed
  • Dashboard
  • Wallet
  • Learn
  • Achievements
  • Network
  • Rewards
  • SharpGPT
  • Premium
  • Register
  • Login
SQL Server

SQL Server Transact Basic to Expert - Display Current date in yy.mm.dd format

  • WhatsApp
  • Karthikeyan Anbarasan Karthikeyan Anbarasan
  • 13y
  • 2k
  • 0
  • 0
    • 25
  • Blog
This blog shows how to display the current dae in yy.mm.dd using SQL query

Example:

SELECT CONVERT(varchar(20), GETDATE(), 102)

The expected result would be 11.06.16
  • SQL Server Transact Basic to Expert - Display Current date in yy.mm.dd format
Up Next
SQL Server SQL Server Transact Basic to Expert - Get Current SQL Server Instance Name
Ebook Download
View all
C# Corner Ebook
SQL Jobs
Read by 0 people
Download Now!
Learn
View all
Learn Image
SQL Server Tutorial
Get Started

You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.

Become a sharper developer and jumpstart your career.

Basic

$0

$

. 00

monthly

Sign-Up Now

For Basic members:

  • Standard Profile
  • Access learning courses
  • Access free e-books
  • 1x point
Premium

$20

$

. 00

monthly

Sign-Up Now

For Premium members:

  • Earn 2x reward points
  • Premium profile with Verified check
  • Premium Avatar with status update
  • Learning courses
  • Unlimited Certifications and badges on profile
  • Unlimited Book downloads
  • Access to Premium content
  • Online Training
  • Unlimited PDF conversions and downloads
  • Professional Resume Writing
  • Interview Preparations Guide
  • 25 messages per month
  • 1 "Kodzu" avatar, basic
Elite

$45

$

. 00

monthly

Sign-Up Now

For Elite members:

  • Bundle E-books
  • Access to all Learn Series
  • Unlimited Apply Jobs
Leaderboard
View all
Sarthak Varshney

Sarthak Varshney
+0
Deepak Tewatia

Deepak Tewatia
+0
View all
Yesterday's leader
Sarthak Varshney  
Sarthak Varshney
Pune (India)
70
102
1.7k
100
Member of the month
Rinki  
Rinki
Chennai (India)
15
5.4k
14.8k
50
Speaker of the month
Shivam Payasi  
Shivam Payasi
C#, .NET
Chitrakoot (India)
8
21.1k
19.7k
10
Upcoming events
View all
  • The Cloud Show with Magnus Mårtensson ft. Oscar Garcia Colon - Ep: 45
  • Bhubaneswar Chapter
  • Building Websites with Microsoft Power Pages: Exploring WebPage, WebTemplate, and Page Templates - Microsoft Business Application Ep. 25
Suggested for you
View all
Rinki Rinki
Follow
Nitin Pandit Nitin Pandit
Follow
Shivam Payasi Shivam Payasi
Follow
Harshit Pandey Harshit Pandey
Follow
Nilesh Jadav Nilesh Jadav
Follow

CSharpBot

About Us Contact Us Privacy Policy Terms Media Kit Partners C# Tutorials Consultants Ideas Report A Bug FAQs Certifications Sitemap Stories CSharp TV DB Talks Let's React Web3 Universe Interviews.help Jumpstart Blockchain Build with JavaScript

©2024 C# Corner.

All contents are copyright of their authors.