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.
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.