error Display Datetime in Specific Format

Question

When I am try to get date between to data and change the Specific Format datetime then error occured. please Help me... select mydate from Tble_xxx where CONVERT(varchar(20) mydate 120) BETWEEN CONVERT(varchar(20) (@startdate 'yyyy-MM-dd HH:m:ss:mmm' 'en-US')  120) AND CONVERT(varchar(20) (@enddate 'yyyy-MM-dd HH:m:ss:mmm' 'en-US') 120)

Bharath Peggem · Answer

Hi Abhilash Try this code may be it will workout. select mydate from Tble_xxx where CONVERT(varchar(20) mydate 120) BETWEEN CONVERT(varchar(20) @startdate 105) AND CONVERT(varchar(20) @enddate105) or http://stackoverflow.com/questions/19451767/datetime-between-statement-not-working-in-sql-server Thanks Bharath Peggem