Converting a column 27:12:2008 to 27.12.2008

  • I've successfully tried this query

    Select Replace('30:06:2008',':','.')

  • Ashok, unless you're using European number formating (where . = , and , = . ) you're 'conversion' won't actualy result in a number. And assuming you did convert it to a validly seperated integer, it's useless for aggregation. Vijay should be able to use one of many standard conversions, he just needs to identify how the minutes for his operations are being stored.

    Steve.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply