SQL table maintenance

keith.corkran's Avatar

keith.corkran

21 Oct, 2010 07:01 PM

In reference to:
http://help.hannonhill.com/discussions/installation/42-deleting-assets
Does anyone know how the date value is created?
My values in the cxml_mail table look like this:
1279910139584
I want to know how to figure out what is old...
Thanks,
Keith

  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

    http://www.phpbuilder.com/board/showthread.php?t=10339782

  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.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? 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