SQL table maintenance

keith.corkran's Avatar


21 Oct, 2010 07:01 PM

In reference to:
Does anyone know how the date value is created?
My values in the cxml_mail table look like this:
I want to know how to figure out what is old...

  1. Support Staff 1 Posted by Tim on 21 Oct, 2010 07:24 PM

    Tim's Avatar

    Hi Keith,

    You'll need to plug that value into a unix time converter like this one. However, when you do so, you'll need to make sure you remove the last 3 digits. So, for this specific time stamp you've supplied, you will want to use 1279910139.

    If you are looking to find a date to start trimming before/after, you can use the Convert a Date/Time to a Unix timestamp section on that page to get a unix time stamp. Once you have that value, add 3 zeros (000) to the end in order to make it compatible with the time stamps in Cascade.

    Let me know if this makes sense.

  2. 2 Posted by keith.corkran on 22 Oct, 2010 11:14 AM

    keith.corkran's Avatar

    Hey Tim,
    Perfect thanks!

    I went ahead and found some supporting info:
    --works in MS SQL declare @UNIX_TIMESTAMP int
    select @UNIX_TIMESTAMP = 1178225057
    select dateadd(ss,@UNIX_TIMESTAMP,'01/01/1970') as theDateTime


  3. Support Staff 3 Posted by Tim on 22 Oct, 2010 01:28 PM

    Tim's Avatar

    Cool. Glad I was able to help out!

  4. Tim closed this discussion on 22 Oct, 2010 01:28 PM.

Discussions are closed to public comments.
If you need help with Cascade CMS please start a new discussion.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac


26 Aug, 2016 01:19 PM
25 Aug, 2016 03:02 PM
25 Aug, 2016 12:50 PM
24 Aug, 2016 08:43 PM
24 Aug, 2016 07:20 PM
21 Aug, 2016 01:20 PM