Aveti mai multe solutii:
1. Construiti o functie prin care sa apelati in interogari toate coloanele de acel tip, exact cum v-a descris Razvan:
1 2 3 4 5 6 7 8 9 | CREATE FUNCTION dbo.fn_ConvertUnixTimeStamp(@UnixTimeStamp bigint) RETURNS datetime AS BEGIN DECLARE @ReturnedDate datetime; SET @ReturnedDate = DATEADD(second,@UnixTimeStamp,'19700101'); RETURN @ReturnedDate; END; GO |
Apelare:
1 2 | SELECT dbo.fn_ConvertUnixTimeStamp(ReceiveTime) AS ReceiveDateAndTime FROM MyTable; GO |
2. Adaugati o coloana calculata la tabelele continand acest tip:
1 2 3 | ALTER TABLE MyTable ADD ReceiveDateAndTime AS DATEADD(second,ReceiveTime,'19700101'); GO |
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro