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