Use below MySQL function to convert one timezone to another timezone.
SELECT CONVERT_TZ(now(),'UTC','Europe/paris') as d;
SELECT CONVERT_TZ(now(),''US/Eastern','US/Central') as d;
Thursday, March 17, 2016
Wednesday, March 9, 2016
mysqlimport: Error: 29, File '/CSVFile' not found (Errcode: 13 - Permission denied), when using table: TableName
- This error occurs due to the permission issue.
- I used following steps to resolve this issue.
These are the steps that i followed to import a CSV data file to MySQL database
- Create a table in MySQL database. CSV file name should be equivalent to the table name that you are going to import.
EX: Table name is : PS_EMPLIDS
- Execute following command
Command to import csv file to MySQL :
mysqlimport --user=mysqlUsername --password=mysqlPassword --ignore-lines=1 databaseName ~/PS_EMPLIDS.csv