Convert DATE in to real

Results 1 to 2 of 2

Thread: Convert DATE in to real

  1. #1
    Join Date
    Dec 1969

    Default Convert DATE in to real

    I have 2 different questions. Please help me<BR><BR>1) Is there anyway I can SUM a field of type date in sql 7.0 ?<BR>2) When i use Cast(FieldofTypeDate as real) it is giving me a value. Does anyone know what is the rule behind the value it returns ?<BR><BR>Tom

  2. #2
    Join Date
    Dec 1969

    Default ?

    What do you mean by sum? I can&#039;t see anything meaningful result from "adding" a datetime to another datetime value.<BR><BR>datetime values are stored as the number of days and seconds that has elapsed since some starting point and it is that value that is returned.

Posting Permissions

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