PDA

View Full Version : Doing a calculation on a derive column within an SQL statement



Salient
09-04-2012, 10:50 PM
Currently have:

SELECT
f.id as sort_key,
dateadd(<DATEPART_S>, f.reported, #01-Jan-1970 00:00:00# ) as dtEntered,
dateadd(<DATEPART_S>, f.actioned, #01-Jan-1970 00:00:00# ) as dtCinema,
dateadd(<DATEPART_S>, f.closed, #01-Jan-1970 00:00:00# ) as dtClosed,
dateadd(<DATEPART_S>, f.expected, #01-Jan-1970 00:00:00# ) as dtDVD,



I want to add something like

convert(varchar,dtEntered,108) as period_index

but can't quite suss it :(

Any help greatfully received.