Author: Alex Barkov Email: [EMAIL PROTECTED] Message: > I use search.cgi > Here is what I have in htdb:/ > > HTDBDoc \ > SELECT concat( \ > 'HTTP/1.0 200 OK\\r\\n',\ > 'Content-type: text/html\\r\\n',\ > 'Last-Modified: ',Date_format(lastpost,'%a, %d %b %Y %T'),' GMT\\r\\n',\ > '\\r\\n',\ > '<HTML><HEAD>',\ > '<TITLE>',title,'</TITLE>',\ > '<META NAME="Description" Content="',title,'">',\ > '<META NAME="Keywords" Content="',title,'">',\ > '</HEAD>\\n',\ > '<BODY>\\n',text,'\\n</BODY></HTML>'\ > ) \ > FROM forum.thread \ > WHERE id='$1' > > Now the lastpost is in the timestamp format like this: 980324760 > > How can I convert it to regular date and time format? >
Well, the field url.last_mod_time is initialized from Last-Modified HTTP header, the stores it in Unix timestamp format in database. In your case it will use Last-Modified,generated from htdb. search.cgi should convert it into readable form, like in the case of usual http document, and displays it when $(DM) is specified in search.htm. Try $(DM), I should display what you want, like this: 2000-01-01 00:00:00 Reply: <http://www.mnogosearch.org/board/message.php?id=4261> ___________________________________________ If you want to unsubscribe send "unsubscribe general" to [EMAIL PROTECTED]
