https://legacy.forums.gravityhelp.com/topic/date-time-fields-storing-at-datetime-instead-of-text Gravity Support Forums Topic: Date / Time fields storing at datetime instead of text? en-US Fri, 10 Apr 2026 17:21:10 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/date-time-fields-storing-at-datetime-instead-of-text#post-29241 Wed, 06 Jul 2011 13:28:39 +0000 Chris Hajer 29241@https://legacy.forums.gravityhelp.com/ <p>ramseyp, the php function <strong>strtotime</strong> works like magic to convert nearly any time or date string into a Unix timestamp so you can use it in your sorts. Can you incorporate that into your code?</p> <p><a href="http://php.net/manual/en/function.strtotime.php" rel="nofollow">http://php.net/manual/en/function.strtotime.php</a> </p> https://legacy.forums.gravityhelp.com/topic/date-time-fields-storing-at-datetime-instead-of-text#post-29156 Tue, 05 Jul 2011 15:20:04 +0000 Carl Hancock 29156@https://legacy.forums.gravityhelp.com/ <p>The data is stored as a serialized array. They aren't stored in individual database columns which require a unique table be created for each form. Because the forms are dynamic, all the data is stored as a serialized array using the same database table structure. </p> https://legacy.forums.gravityhelp.com/topic/date-time-fields-storing-at-datetime-instead-of-text#post-29151 Tue, 05 Jul 2011 14:58:55 +0000 ramseyp 29151@https://legacy.forums.gravityhelp.com/ <p>Hi all, I was wondering why date &amp; time fields are being stored as text instead of the datetime format. I'm trying to do some sorts &amp; the fields not being converted to a timestamp makes it more difficult. Just curious if this was going to change, if there's a reasonable fix I can apply, etc.</p> <p>Cheers! </p>