Date and Time Control

Posted Date: 17 Jun 2010 Posted By:: Narasimha Member Level: Silver Member Rank: 2040 Points: 1 Responses: 1

Hi all,

How to change datetime control format at run time and how to get and convert date and time formates into customized format

Like :
dd/MM/yyyy
mm/dd/yyyy

Responses

#517722 Author: Lion Member Level: Gold Member Rank: 117 Date: 17/Jun/2010 Rating: Points: 2
Hi, For mm/dd/yyyy Select CONVERT (nvarchar(10), GETDATE(),102) For dd/mm/yyyy Select CONVERT (nvarchar(10), GETDATE(),103) Hope it will help ful Thanks & Regards Lion Jaipur (Pink City) India My Blog

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : File Header
	Previous : Serial Number in RDLC report.
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Follow us on Twitter: https://twitter.com/dotnetspider

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription