Solved

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

Posted on 2008-06-09
3
211 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
3 Comments
 
LVL 142

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now