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.

  Home  |   Contact  |   Syndication    |   Login
  90 Posts | 0 Stories | 78 Comments | 7 Trackbacks

News




Google RankGoogle PR™ - Post your Page Rank with MyGooglePageRank.com



The content on this site represents my own personal opinions and thoughts at the time of posting, and does not reflect those of my employer's in any way.

Disclaimer:- All postings in this blog is provided "AS IS" with no warranties, and confers no rights.

Archives

Post Categories

Image Galleries

Atlas

Error

OutLook

SharePointService

Usefull Site Links

Function to Convert DateTime to DD/MM/YYYY format + SQL SERVER
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
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
posted on Tuesday, April 01, 2008 9:40 PM

Feedback

# re: Function to Convert DateTime to DD/MM/YYYY format + SQL SERVER 9/8/2009 6:32 AM paramvir





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.


Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: