A query which returns DDMMYYYY from MMDDYYYY Date format

Posted Date: 23 Dec 2008	Resource Type: Code Snippets	Category: SQL
Author: Prashant Mishra	Member Level: Bronze
Rating:	Points: 5

Example:- A query which return DDMMYYYY from MMDDYYYY Date format



select cast(DATEPART (dd,getdate())as varchar(10))
+'/'+ cast(DATEPART (mm,getdate()) as varchar(10))
+'/'+ cast(DATEPART (yyyy,getdate()) as varchar(10)) as dat from table

Responses

Author: Sumit 26 Dec 2008 Member Level: Silver Points : 0

It Is Good One

i Need It

Regards
Sumit
sumi2987@gmail.com

Feedbacks

Popular Tags

What are tags ?

Search Tags

Date conversion .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Get Third Max Salary
	Previous Resource: Delete Duplicate records from the table database
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources