Results 1 to 3 of 3

Thread: (SQL2005) Format date and currents

  1. Jun 15th, 2007, 08:45 AM #1
    GARAKWAZVO
    GARAKWAZVO is offline

    Thread Starter
    Member GARAKWAZVO's Avatar
    Join Date
    Mar 2007
    Location
    Zimbabwe
    Posts
    56

    (SQL2005) Format date and currents

    How do i format date and currents in a query such that the output is: for currents $ ### ###,## and DD/MM/YYYY ?
    Reply With Quote Reply With Quote
  2. Jun 19th, 2007, 08:23 PM #2
    Coke
    Coke is offline
    Junior Member Coke's Avatar
    Join Date
    Mar 2007
    Posts
    31

    Re: (SQL2005) Format date and currents

    u can try formatting the fields that you display at.
    Reply With Quote Reply With Quote
  3. Jun 20th, 2007, 06:30 AM #3
    faizee36
    faizee36 is offline
    Member
    Join Date
    Mar 2007
    Posts
    32

    Re: (SQL2005) Format date and currents

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width