Using a time_stamp field on Search and Results pages via DataAssist

Regarding a time_stamp field in the db, may I check facts for the Search and the Results pages generated by DataAssist, please?

So far I am not succeeding to use that field effectively.

On the Search page, the time_stamp field is set to display as Datepicker, the default. (I tried setting it to Text, for one iteration. Did not improve things.)

On the Results page, the results displayed for the time-stamp show only the date, not the time also.


Two issues, here:

One, an entry on the Search page, in the time_stamp field (of course via Datepicker), does not return any result.

However, when using another field (a field that is entered upon Insert, a date field selected manually), results can be satisfactorily retrieved. And the display on the Results page – now visible for the time_stamp too – then shows what was entered in the failed attempt previously, to Search on the time_stamp field,.

Puzzling, of course. Can time_stamp be used as a field to search, and of course what will make it work if so?

Two, can the display on the Results page be set to show time with the date?

Thanks,

David

A time stamp field can only be queried by exact match, so a date picker field cannot be used to query it.

a timestamp stores the data in the format:

yyyy-mm-dd hh:ii:ss

when querying the time stamp, you need to match the entire time stamp including the time portion.

a datepicker will only send the year month day portion of the date. since it doesn't include the time portion, it will not be able to make a match.


as for dis[p;laying it on the results page, it probably uses the date function and converts the format to not include the time, you could edit the formatting to include the time,

Thanks, much, Jason. That clarifies.

And a search, to w3c, showed formats. Adding

h:i:sa

in the existing date function, did it. (Though I am a little mystified why there is an 'n,' rather than an 'm,' for the month, in the existing function … but it works.)

Again thanks.

n for the month is numeric representation without leading 0s:
http://php.net/manual/en/function.date.php


so it will show January as:
1

instead of:
01

Right. And that PHP documentation is now top of my tech bookmarks. Now it is clear where to find.

Thanks.