how to define data type and size from a format function call ?

• allan.ford17

  SSC Eights!

  Points: 944

  More actions

  March 11, 2019 at 4:43 pm

  #374630

  I am wondering:

  how to define data type and size from a format function call ?

  If I define a view like this one, or similar ..  then the column resulting from the format statement is a nvarchar(4000) ..

  create view
[Clinical].[AAA_Scratch_View]
as
select
format ( getdate() , 'yyyy-MM-dd HH:mm:ss') as [getdateoutput]

  If I am wanting a varchar(19) then this seems to work .. Is this the best way / only way ?

  alter view
[Clinical].[AAA_Scratch_View]
as
select
CONVERT(VARCHAR(19), format ( getdate() , 'yyyy-MM-dd HH:mm:ss') ) as [getdateoutput]

• jonas.gunnarsson 52434

  Ten Centuries

  Points: 1240

  More actions

  March 12, 2019 at 1:47 am

  #2024171

  You may want to use convert
  select convert(varchar(19), getdate(), 120) as [getdateoutput];