converting Epoch timestamp to sql server(human readable format)

by

I have 3 different columns with the same format. How can I change the values in those columns.

To update 3 columns in a table, you can pair DATEADD seconds to the epoch (1 Jan 1970) with the column name, i.e.

update tbl set
    datetimecol1 = dateadd(s, epochcol1, '19700101'),
    datetimecol2 = dateadd(s, epochcol2, '19700101'),
    datetimecol3 = dateadd(s, epochcol3, '19700101')

You can’t update in place since a bigint column cannot also be a datetime column. You have to update them into 3 other columns.

More Related Contents:

  1. How can I do an UPDATE statement with JOIN in SQL Server?
  2. Not equal != operator on NULL
  3. How can I select the first day of a month in SQL?
  4. Subquery using Exists 1 or Exists *
  5. Truncate (not round) decimal places in SQL Server
  6. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  7. Dynamically create columns sql
  8. Reference alias (calculated in SELECT) in WHERE clause
  9. TSQL PIVOT MULTIPLE COLUMNS
  10. INT vs Unique-Identifier for ID field in database
  11. Why do you create a View in a database?
  12. SQL query to find Nth highest salary from a salary table
  13. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  14. Calculate the number of records for each date between 2 dates
  15. T-SQL: How to use parameters in dynamic SQL?
  16. Get the records of last month in SQL server
  17. How to compare datetime with only date in SQL Server
  18. Merge overlapping date intervals
  19. I want to use CASE statement to update some records in sql server 2005
  20. SQL server select distinct rows using most recent value only
  21. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  22. alternatives to REPLACE on a text or ntext datatype
  23. Split words with a capital letter in sql
  24. SQL poor stored procedure execution plan performance – parameter sniffing
  25. How to return a incremental group number per group in SQL
  26. Eliminate and reduce overlapping date ranges
  27. scope_identity vs ident_current
  28. COALESCE Function in TSQL
  29. Convert bigint to datetime
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment