Query generation

Question

I have created A table in sql server having following field
Name,
Created time,
Created date,

I want to display all the record of this table where created date will be system date and created time will before the current system time but on the current sytem date

Plz help me In generating this query

Answer 1

0

Select Name, [created time], [created date] 
from ATable 
where [created date] = [system date] 
and [created time] < [system time]

might be what you want but as Kev says, it may well revolve around your data types.

I would also add its not a good practice to use column names with spaces, if you want to make them more readable then use an underscore, such as "created_date".

answered Nov 13 '10 at 03:14 PM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104

Oh no! You did it!! You have started the naming-conventions-discussion!!!

The advice should of course be: "If you want to make them more readable, then use PascalCase"

Sorry. Couldn't resist. Please ignore this comment... :)

Nov 13 '10 at 03:22 PM Magnus Ahlkvist

Impossible to ignore - I love it!

A blatant "case" of camelCase envy :)

Nov 13 '10 at 07:16 PM KenJ

...and name any foreign key columns exactly the same as the primary key columns they reference so BI tools like QlikView and PowerPivot can infer the relationships automatically. Nothing funny here, just saying...

Nov 13 '10 at 09:12 PM Scot Hauder

(comments are locked)

Query generation

Follow this question

Related Questions