Solved

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

Posted on 2008-06-09
3
246 Views
Last Modified: 2010-04-21
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.
0
Comment
Question by:MyDanes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 21744733
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
 
LVL 60

Expert Comment

by:chapmandew
ID: 21744735
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
 

Author Closing Comment

by:MyDanes
ID: 31465463
Thank you so much  - as usual PERFECT help
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question