Home Forums SQL Server 2008 Working with Oracle Convert date format in SQL sever report(BIDS) with Oracle date format RE: Convert date format in SQL sever report(BIDS) with Oracle date format
Seattlemsp
SSC Eights!
Points: 932
More actions
January 27, 2012 at 1:51 pm
#1439607
I got it!
I made it too complex. It shoudl be just use :mydate instead of @mydate. Only drackback is the user has to put in the correct date format --- DD-Mon-YYYY
Thanks you all!