Results 1 to 2 of 2

Thread: Challenge to all Guru

  1. Apr 18th, 2001, 05:14 PM #1
    Mark_Meng
    Mark_Meng is offline

    Thread Starter
    Lively Member
    Join Date
    Mar 2001
    Location
    Springfield
    Posts
    120
    I have a decimal no 36997.6950553241. If I use cdate(36997.6950553241) in vb, the date returned just 2 days before I use convert(datetime, 36997.6950553241) in SQL server. Can anybody explain this???
    MM
    Reply With Quote Reply With Quote
  2. May 8th, 2001, 05:50 AM #2
    Bill Crawley
    Bill Crawley is offline
    Fanatic Member
    Join Date
    Feb 2000
    Location
    Dunmow,Essex,England
    Posts
    898
    Part of the problem will be due to rounding. SQLServer can handle larger decimals than VB. Not sure why you want to do a Cdate on a decimal though, the fact that it returned 2 days before I suspect was a fluke. I'd be surprised if it was consistant.
    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