Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Convert date format in SQL sever report(BIDS) with Oracle date format Expand / Collapse
Author
Message
Posted Friday, January 27, 2012 1:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 2:06 PM
Points: 32, Visits: 64
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!
Post #1243129
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse