0

This will be simple for you. I have a query that returns all the information in the table but the dates are all Unix timestamp and I need to convert that one column.

These are my 2 strings and I just need to know how to link them together:

Query 1:

SELECT * FROM `wrd_project_payment_transactions`

The conversion: 

SELECT  CONVERT_TZ(FROM_UNIXTIME(`datemade`), @@session.time_zone, '+00:00')  
FROM  `wrd_project_payment_transactions`

I'm a noob so be gentle.

Thanks!

fedorqui
  • 275,237
  • 103
  • 548
  • 598
user3003638
  • 1
  • 3

1 Answers1

1
SELECT *, CONVERT_TZ(FROM_UNIXTIME(`datemade`), @@session.time_zone, '+00:00') AS convertedTime  
FROM  `wrd_project_payment_transactions`
Digital Chris
  • 6,177
  • 1
  • 20
  • 29