Date time function

Posted Date: 26 Nov 2008	Resource Type: Code Snippets	Category: SQL
Author: Deepika Haridas	Member Level: Diamond
Rating:	Points: 2

This is a sample SQL DateTime Funtion in month,day,year for SQL.


CREATE FUNCTION dbo.GetDateOnly ( @InputDate DATETIME )
RETURNS DATETIME
BEGIN
RETURN CAST(CONVERT(VARCHAR(10), @InputDate, 111) AS DATETIME)
END
GO

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

DateTime .

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: Code Geting column name of Excel sheet to create sql table
	Previous Resource: OPENXML
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

More Resources

Code Geting column name of Excel sheet to create sql table
How to create a user account database
Returning String Instead of NULL
Accessing SQL Server in VB.NET
Begin tran in Stored Procedure
Generate Bill Number with year prefix