PDA

Click to See Complete Forum and Search --> : (SQL2005) Format date and currents

GARAKWAZVO
Jun 15th, 2007, 08:45 AM
How do i format date and currents in a query such that the output is: for currents $ ### ###,## and DD/MM/YYYY ?
Coke
Jun 19th, 2007, 08:23 PM
u can try formatting the fields that you display at. :)
faizee36
Jun 20th, 2007, 06:30 AM
Hi you can convert your date to UK format in your sql query like this

Select CONVERT (nvarchar(20), Yourdate, 103)

then use this value in your report
thanks