Hostname
| From: | Darren Young | Date: | Tue, 09 Jul 2002 20:42:36 +0000 |
| Subject: | Hostname | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20433@lists.php.net to get a copy of this message | ||
Is there a SQL hostname function that'll return the name of the host a db
is running on? MySQL has the a SYSDATE() function, does anyone know of a
HOSTNAME() function in SQL and/or MySQL? I know that I can find it either
from the OS or in PHP, however the need right now is to have it in the SQL
script itself.
Another one if anyone here is familiar with MySQL. When I do an INSERT
that contains the SYSDATE() function, it's inserted in GMT. Is there
possibly a way to have it INSERT in local time (CST)?
Thanks,
Darren Young
darren@younghome.com