SQL table maintenance
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
Discussions are closed to public comments.
If you need help with Cascade CMS please
start a new discussion.
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
Support Staff 1 Posted by Tim on 21 Oct, 2010 07:24 PM
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 Posted by keith.corkran on 22 Oct, 2010 11:14 AM
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
Support Staff 3 Posted by Tim on 22 Oct, 2010 01:28 PM
Cool. Glad I was able to help out!
Tim closed this discussion on 22 Oct, 2010 01:28 PM.