Solved

How do I find next day date by end time ?

Posted on 2014-09-29
8
306 Views
Last Modified: 2014-10-01
I have db with these details

Title (text)
Date Start Time (Timestamp)
Date End Time  (Timestamp)

Open in new window


I will get input as

"This is title"
09/29/2014
11:55 PM
03:35 AM

Open in new window


Now I need to calculate based on end time "03:35 AM".. the next day as "09/30/2014"?

How can I do this?

attached are my sample input screen.
0
Comment
Question by:Loganathan Natarajan
  • 5
  • 3
8 Comments
 
LVL 109

Assisted Solution

by:Ray Paseur
Ray Paseur earned 500 total points
ID: 40349913
0
 
LVL 109

Expert Comment

by:Ray Paseur
ID: 40349919
Now I need to calculate based on end time "03:35 AM".. the next day as "09/30/2014"?
How do you figure out that the next day is 09/30/2014?  Is this value always the current date + 1 day?  Give us a little more to go on, and I'll be glad to show you the calculations (or just read the article and you'll find many examples of date/time arithmetic).
0
 
LVL 36

Author Comment

by:Loganathan Natarajan
ID: 40350254
Thanks Ray, let me go through your article first.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 109

Expert Comment

by:Ray Paseur
ID: 40350338
OK.  Once we know the rules for interpreting the times, it should be pretty easy to get the code together.
0
 
LVL 36

Author Comment

by:Loganathan Natarajan
ID: 40351497
I read the tutorial , it is useful and more details to work further. Thanks Ray.

but in my case different, just check the attachment screen. the input comes always one DATE and FROM, TO time ...

So, what is the best way to validate in my case?
doubt.png
0
 
LVL 109

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 40352087
I'll try to show you what I think might work.  Install this script and run it, or test on my server here.
http://iconoun.com/demo/temp_loganathan.php
<?php // demo/temp_loganathan.php
error_reporting(E_ALL);
if (!empty($_GET))
{
    // INTERPRET THE DATES INTO TIMESTAMPS AND ISO-8601 DATETIME VALUES
    $alpha = date('c', strtotime($_GET['d'] . ' ' . $_GET['a']));
    $omega = date('c', strtotime($_GET['d'] . ' ' . $_GET['z']));

    // IF THE END DATE/TIME IS EARLIER THAN THE START, ADD A DAY
    if ($omega < $alpha) $omega = date('c', strtotime($omega . ' + 1 DAY'));

    // SHOW THE UNDERSTANDING OF THE DATES
    echo "Alpha: $alpha, Omega: $omega";
}

// CREATE THE FORM FOR INPUTS
$form = <<<EOF
<form>
Date:  <input name="d" /><br>
Start: <input name="a" /><br>
End:   <input name="z" /><br>
<input type="submit" value="Go!" />
</form>
EOF;
echo $form;

Open in new window

0
 
LVL 36

Author Comment

by:Loganathan Natarajan
ID: 40353936
Thanks ray. It is very helpful and fixed it.
0
 
LVL 109

Expert Comment

by:Ray Paseur
ID: 40354228
Great!  Thanks for the points, ~Ray
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

813 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

16 Experts available now in Live!

Get 1:1 Help Now