select query I want to select 'today's date' as part of my select

select account_id, ***date- Todays date**** format YYYYMMDD with no spaces etc from cashmgmt_payment

also how can I make it so there are no 'header' or footer records so the output is something like:

123   20041224

no reference to rows selected or no header before JUST the result set.
MyDanesAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
the "header" is the output settings of the query tool...

the rest should be like this:
select account_id, convert(varchar(10), getdate(), 112) from cashmgmt_payment

Open in new window

0
 
chapmandewCommented:
select convert(varchar(10), getdate(), 112)
from tablename

as for the headers, view the results as text.  Go to tools, options...there is an option for not showing the headers.
0
 
MyDanesAuthor Commented:
Thank you so much  - as usual PERFECT help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.