GETDATE() works alone as default in a DateTime column, but:
1) How do you include current Date concatenated with text like:
- Column default Value = 'Submitted 2007-07-30 13:15:54.953'
2) is it possible to truncate that DateTime value (deleting the seconds 54.953)
- Final Column default Value = 'Submitted 2007-07-30 13:15'
Thinking Cast or convert but unsuccessful to date:
- 'Submitted ' + Cast(CHAR(16),GETDATE()) ?
I think the short answer here is, 'Yes'; it is just a matter of getting the format that you want. Here is an example:
Code Snippet
declare @.what table (aVc varchar(30) default('Submitted ' + left(convert(varchar, getdate(),120), 16)) )
insert into @.what default values
select * from @.what
/*
aVc
Submitted 2007-07-30 13:15
*/
Giving it another look you might want to try making your default
default('Submitted ' + convert(varchar(16), getdate(),120))
Might simplify the expression a bit.
|||Thanks Kent!
