Geeks With Blogs
Gaurav Taneja Great dreams... never even get out of the box. It takes an uncommon amount of guts to put your dreams on the line, to hold them up and say, "How good or how bad am I?" That's where courage comes in.
Function to Convert DateTime to DD/MM/YYYY format

CreateFUNCTION [dbo].[tkfunConvertDateToDDMMYYYY](@dtDate varchar(10))
    RETURNS datetime
AS
BEGIN
    RETURN Convert(datetime,substring(@dtDate,4,2)+'/'+substring(@dtDate,1,2)+'/'+substring(@dtDate,7,4))
END Posted on Tuesday, April 1, 2008 9:40 PM SQL SERVER | Back to top


Comments on this post: Function to Convert DateTime to DD/MM/YYYY format + SQL SERVER

# re: Function to Convert DateTime to DD/MM/YYYY format + SQL SERVER
Requesting Gravatar...





select Entry_Date ,Amount,PaymentMode,ChequeOrDD_No,BankName,PaymentParticulars from
tb_retailerpayments where retailer_id = 1 and Entry_Date between CONVERT(VARCHAR(19),@reprtdatefrom())
and CONVERT(VARCHAR(19),@reportdateto())
loking for thid convertion help me.
Left by paramvir on Sep 08, 2009 6:32 AM

Your comment:
 (will show your gravatar)


Copyright © Gaurav Taneja | Powered by: GeeksWithBlogs.net