Inserting Datetime(different timezone) value

[obrienkev]

Hi all,

I have a query to insert a file details into DB...

INSERT INTO excel(name, file_date) values('$fileName', {fn NOW()})

How do I ensure the datetime value is saved with a value of minus 5hours?

The server runs on GMT time but I want files saved with BST time.

Thanks.

Kevin.

[jheitz]

Check this link for MySQL functions to convert Dates from one Timezone to another:

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html