Skip navigation
lovewebdev
lovewebdev
Currently Being Moderated

Difference between 2 timestamps

Mar 12, 2012 1:22 PM

I'm not sure why my results are giving me 0. I'm trying to do a simple date difference. Here's my code:

 

<cfset nowtime = now()>

 

<cfif DateDiff("s", getpost.dtstamp, nowtime) lt 60>

  <cfset thedate = DateDiff("s", getpost.dtstamp, nowtime)  & " seconds ago">

 

  <cfelseif DateDiff("m", getpost.dtstamp, nowtime) lt 60>

  <cfset thedate = DateDiff("m", getpost.dtstamp, nowtime)  & " minutes ago">

 

   <cfelseif DateDiff("h", getpost.dtstamp, nowtime) lte 23>

  <cfset thedate = DateDiff("h", getpost.dtstamp, nowtime)  & " hours ago">

 

 

  <cfelseif DateDiff("d", v.dtstamp, nowtime) lte 7>

  <cfset thedate = DateDiff("d", getpost.dtstamp, nowtime) & " days ago">

 

    <cfelse>

  <cfset thedate = dateformat(getpost.dtstamp, "mmmm dd")>

</cfif>

 

 

When I displayed the original variables it shows:

 

getpost.dtstamp = 2012-03-10 17:33:25.0 I don't know where this .0 is coming from because the database doesn't show that.

now = {ts '2012-03-12 16:16:02'}

 

I'm getting 0.

830 Views   9 Replies   Latest reply: -==cfSearching==-, Mar 12, 2012 11:37 PM
 
Replies
  • -==cfSearching==-
    Currently Being Moderated
    1. -==cfSearching==-,
    Mar 12, 2012 1:40 PM   in reply to lovewebdev
    Report

    Zero what: seconds ago, minutes ago, ....?  What is the data type of the dtstamp column?

     

    <cfelseif DateDiff("d", v.dtstamp, nowtime) lte 7>

    Btw, are you intentionally using a different variable there?

     
    |
    Mark as:
  • lovewebdev
    Currently Being Moderated
    2. lovewebdev,
    Mar 12, 2012 2:05 PM   in reply to -==cfSearching==-
    Report

    Just a mistake as I pasted my code on the forum it should be the same as the variables above it. That's not the cause of the error

     
    |
    Mark as:
  • -==cfSearching==-
    Currently Being Moderated
    3. -==cfSearching==-,
    Mar 12, 2012 2:07 PM   in reply to lovewebdev
    Report

    That was just an fyi in case it was not a copy/paste error ;-)

     

    What about the first two questions?

     
    |
    Mark as:
  • Dan Bracuk
    Currently Being Moderated
    4. Dan Bracuk,
    Mar 12, 2012 2:40 PM   in reply to lovewebdev
    Report

    When in doubt, look at your data.  What does this give you?

     

    <cfdump var = "nowtime is #nowtime# dtstamp is #getpost.dtstamp# datediff seconds is  #DateDiff("s", getpost.dtstamp, nowtime)#">

     
    |
    Mark as:
  • lovewebdev
    Currently Being Moderated
    5. lovewebdev,
    Mar 12, 2012 8:46 PM   in reply to -==cfSearching==-
    Report

    @-==cfSearching==- oh sorry. I missed that. So all results are stuck at saying "0 minutes ago"

     

    and the column is a timestamp mysql

     

    @dan same thing. it dumps the seconds correctly but just stops at the minutes and says 0 minutes. it goes no further, even though all differences between posts are way past 60 minutes.

     
    |
    Mark as:
  • lovewebdev
    Currently Being Moderated
    6. lovewebdev,
    Mar 12, 2012 8:50 PM   in reply to lovewebdev
    Report

    I don't know if the error is being caused by that random .0. I don't even know where it's coming from. I checked the value of the timestamp column and there is no .0 in there but this is what's dumping out.

     

    getpost.dtstamp = 2012-03-10 17:33:25.0

     
    |
    Mark as:
  • -==cfSearching==-
    Currently Being Moderated
    7. -==cfSearching==-,
    Mar 12, 2012 8:58 PM   in reply to lovewebdev
    Report

    Okay, that explains it. You have got the wrong DateDiff unit.  "m" stands for months, not minutes.

     
    |
    Mark as:
  • lovewebdev
    Currently Being Moderated
    8. lovewebdev,
    Mar 12, 2012 9:11 PM   in reply to -==cfSearching==-
    Report

    OMG! thanks. I always forget n for minutes lol

     
    |
    Mark as:
  • -==cfSearching==-
    Currently Being Moderated
    9. -==cfSearching==-,
    Mar 12, 2012 11:37 PM   in reply to lovewebdev
    Report

    I don't if the error is being caused by that random .0. I don't even know where it's coming from.

    I checked the value of the timestamp column and there is no .0 in there but this is what's dumping out.

    getpost.dtstamp = 2012-03-10 17:33:25.0

     

     

    That is just a user friendly representation of the timestamp value as a string. Internally, it is a big unreadable number xxxxxxxxx. But since you are not performing a string comparison, its not relevant.

     

    Message was edited by: -==cfSearching==-

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points