-
Doing a calculation on a derive column within an SQL statement
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules