Question
May 19, 2009 at 08:25 AM
ken.clarke

MSSQL

by ken.clarke . Updated 17 years, 3 months ago

Hi,

In MSSQL I would like to select the date in a list of columns but I want the column name of the date to be the date itself eg.
select
column1 as “Stuff1”,
count(*) as “Count”,
getdate() as “Time/Date”
from
table.stuff

instead of displaying “Time/Date” as the column heading I want to display for example “19/05/2009 16:24”

This discussion is locked

All Comments