error Display Datetime in Specific Format

Abhilash J A

10y960

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)

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Bharath Peggem10y ago

Accepted 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), @enddate,105)

or

http://stackoverflow.com/questions/19451767/datetime-between-statement-not-working-in-sql-server

Thanks,

Bharath Peggem