This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.
How do I get the next/top 5 events based on a date range?
I have a database of events for the next 12 months.
How do I query the top 5 events based on today's date for the next 6 months?
What is the syntax for the today's date and six months from now?
I've tried this:
$query = 'SELECT TOP 5 date
,startTime
,endTime
,title
,details
,room
FROM
WWW.dbo.Events
WHERE date BETWEEN (today) and (six months from today)
ORDER BY date DESC';
How do I query the top 5 events based on today's date for the next 6 months?
What is the syntax for the today's date and six months from now?
I've tried this:
$query = 'SELECT TOP 5 date
,startTime
,endTime
,title
,details
,room
FROM
WWW.dbo.Events
WHERE date BETWEEN (today) and (six months from today)
ORDER BY date DESC';
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
when I do that it says:
Notice: Array to string conversion
how would I use the dates in the query above?
Notice: Array to string conversion
how would I use the dates in the query above?
ok, I can get the dates I need in the proper format this way:
$today = date("Y-m-d");
echo $today;
$sixmonths = mktime(0,0,0,date("m"),dat
echo "<br>Six Months is ".date("Y-m-d", $sixmonths);
but when I add them to my query they say they are not columns?
$today = date("Y-m-d");
echo $today;
$sixmonths = mktime(0,0,0,date("m"),dat
echo "<br>Six Months is ".date("Y-m-d", $sixmonths);
but when I add them to my query they say they are not columns?
Should be the following:
SELECT TOP 5 date ,startTime ,endTime ,title ,details ,room
FROM WWW.dbo.Events
WHERE date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY date DESC';
SELECT TOP 5 date ,startTime ,endTime ,title ,details ,room
FROM WWW.dbo.Events
WHERE date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY date DESC';
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name '$today'.' in C:\inetpub\wwwroot\db2.php
Doing it that way:
$query = "SELECT TOP 5 date, startTime, endTime, title, details, room
FROM WWW.dbo.Events
WHERE date BETWEEN '" . $today . "' and '" . $sixmonths . "'
ORDER BY date DESC;"
$query = "SELECT TOP 5 date, startTime, endTime, title, details, room
FROM WWW.dbo.Events
WHERE date BETWEEN '" . $today . "' and '" . $sixmonths . "'
ORDER BY date DESC;"
Premium Content
You need an Expert Office subscription to comment.Start Free Trial