Home > database >  How similar timestamp text type data into time
How similar timestamp text type data into time

Time:09-28

Varchar data type






How to translate into time? (try to modify the column type for the date, but prompt failure)

CodePudding user response:

The select dateadd (hour, 8, dateadd (s, convert (int, '1496246518'), '1970-1-1'))
  • Related