21 Apr
2008
21 Apr
'08
8:10 p.m.
Hello,
On 04/21/08 16:21, Geir O. Jensen wrote:
I'm trying to get a timestamp from the sql server
with the following:
avp_delete("$(avp(s:rds_time))");
avp_db_query("SELECT time FROM usr_status WHERE
cid='$ci';","$(avp(s:rds_time))");
HOWEVER, even if the time field is "2008-04-21 15:06:33" the avp is only
filled with "2008". Any idea what's going on ??
what is the type of the column in database and operating system you are
using?
There might be some issues on specific systems when converting from
datetime to string or integer values that are used with AVPs. Try to
wrap the datetime column with DATE_FORMAT(...) or UNIX_TIMESTAMP(...)
-- these functions return string or integer values.
Cheers,
Daniel
|**|
- gojensen
UNINETT
_______________________________________________
Users mailing list
Users(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
--
http://www.asipto.com