• 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
  • 1.9k
  • 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
Functions in SQL Server: Practical Guide
Read by 5.2k 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
Satyam Sinha

Satyam Sinha
+0
Deepak Tewatia

Deepak Tewatia
+0
Shivam Payasi

Shivam Payasi
+0
View all
Yesterday's leader
Deepak Tewatia  
Deepak Tewatia
C#, Asp.net, DB, F#, AI, MVC
India
12
18.5k
16.5k
50
Member of the month
Rinki  
Rinki
Chennai (India)
15
5.8k
14.2k
50
Speaker of the month
Shivam Payasi  
Shivam Payasi
C#, .NET
Chitrakoot (India)
8
21.7k
19.3k
10
Upcoming events
View all
  • Bhubaneswar Chapter
  • Building Websites with Microsoft Power Pages: Exploring WebPage, WebTemplate, and Page Templates - Microsoft Business Application Ep. 25
Suggested for you
View all
Allen James Allen James
Follow
Alistair Cook Alistair Cook
Follow
Ben Chris Ben Chris
Follow
Nilesh Jadav Nilesh Jadav
Follow
Rathrola Prem Kumar Rathrola Prem Kumar
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.