[datetime] Forum Topics

Hi, how can I make sure that all the datetime stored previously by user input will be updated in a cycle for? I explain better the structure Combobox2 <----- is where list of datatime are previously stored Combobox3 <------- is where remaining time is given by a substraction of two …

Please let me give more details $datetime1 = new DateTime($orderdate); $datetime2 = new DateTime($currdate); $interval = date_diff($datetime1, $datetime2); $interval->format('%m months'); $months_diff = $interval->format('%m months'); for($i = 1; $i <=($months_diff+1); $i++){ $totalFees = $fees + $totalFees;

Hi, I am developing a system that need to monitor machines' licence, so i have a field 'movedate' and 'outdate' every machines can only been kept for 2 years for most. and if the machine didn't go out for almost 2 years, an alert will come out to remind the …

I want to not include the penalties from Sunday , only Monday - Saturday only using this borrowdate,returndate, and currentdate Thankyou! $borrowdate = new Datetime($row['date_return']); $returndate = new Datetime($row['due_date']); $currentdate = new Datetime(); $fines = 0; if($currentdate > $returndate){ $days = $borrowdate->diff($returndate ?? $currentdate, true)->days; echo "₱ ". $fines = …

I have a mysql database that has a Date Received entry and a Date Sent entry. I would like to calculate how many hours in between. This is what I have... $strStart = $row['Date_Received']; $strEnd = $row['Date_Sent']; $dteStart = new DateTime($strStart); $dteEnd = new DateTime($strEnd); $dteDiff = $dteStart->diff($dteEnd); print $dteDiff->format("%H:%I:%S"); …

Sir I have these codes $start_time=$row['start']; //2017-02-09 15:04:09.000 $stop_time=date('Y-m-d H:i:s'); //2017-02-09 16:24:22.000 $duration=$start-$starttime; // it says 2016 but i need result like this //0001:20:13 I mean I need hours in 4 digits minutes in 2 digits and second 2 digits Please help

Always get really confused when dealing with timezones... I have a string `8/11/2013`, which I apply the following code: $firstDate = new DateTime($rawData[$backdate][0]); $firstDate = $firstDate->format('d/m/Y'); The issue is that PHP seems to think that the '11' is the day, when it's actually the month (I'm in NZ). When I …

Hey guys, Using PHP I store a datetime in a mySQL table. I am trying to draw that out and reformat the time. The datetime is contained within the array $user_data['6'] and the format in the mySQL table is set to datetime. The error I'm getting is Call to a …

Hi everyone, i need help here.. i want to calculate age of user.... but i am getting this error ****Catchable fatal error: Object of class DateInterval could not be converted to string in C:\xampp**** while($row=mysqli_fetch_assoc($data)) { $date=$row['Dateofbirth']; } $dob= new DateTIME($date); $interval=$dob->diff(new DateTIME);

hi i have the following error in my sent message file Warning: date_diff() expects at least 2 parameters, 1 given in /home/letsswin/public_html/sent_mail.php on line 146 Show Heres code section for error <?php $lastlog = mysql_fetch_array(mysql_query(" select * from user_lastlogin where online_status = '1' and user_id = '".$user_id."' ")); $start_date = …

Hi guys, I'm following an example from a book (incidentally I'm amazed how many mistakes I've found in pretty much all the MVC books I've so far consulted) and I think I've found where the error is by going line by line, compile and executing the app. Basically, this is …

This is just for fun. You know how old you are(I hope), but do you know how many days you are walking around on this planet? The two routines presented here could be used more practically in an ever present employee application.

Hi guys. I have a date in format "2015-04-04 10:50" (yyyy-MM-dd hh:mm) I'm having a tough time finding a way to alter this date if a condition is met. The condition is not the problem, I can get a true of false but the conversion is proving difficult to fathom …

I am not getting the totalapps any body help me <?php $event_time = "9:30 am"; $end_time="11:00 am"; $event_length = 4; $dtime_1 = new Datetime($event_time); $dtime_2 = new Datetime($end_time); $diff = $dtime_1->diff($dtime_2); $hourone=$diff->format('%H'); $minuteone=$diff->format('%I'); $hourtotalmin=$hourone*60; $totalmin=$minuteone+$hourtotalmin; $totalapps=$totalmin/$event_length; echo $totalapps; ?>

Hi, I am trying to create a sort of day planner with task a start_time and an end_time both entered as string using concatination of comboboxes(hour:minute:second AM/PM) and saved in a database as Datetime I try diferent conversion i found online but it doesn't work. Does anybody have an idea …

I have the following code: if (filtro.FinalDate != null) { FinalDate = String.Format(" Data <= '{0}' ", filtro.FinalDate.GetValueOrDefault().ToString("yyyy-MM-dd") + " 23:59:59"); } But when I compile and type something in the FinalDate, the following message appears in the log: Could not convert string to DateTime: 18/11/2014. Path 'FinalDate', line 1, …

hello. i was just wondering if it is possible to insert data for date and time separately into database for a column with type datetime. datetime format is like : yyyy-mm-dd h:m:s . I know you can get date and time separately FROM database but is it possible to be …

Hi guys I want to convert the following string to datetime format but not sure how to go from here Any help is appreciated. Thanks! 2013063018 to 30/06/2013 18:00 string date = strFields[0]; //string format = "ddMMyyyHH"; DateTime dt = DateTime.ParseExact(date, "dd/mm/yyyy hh:ss", CultureInfo.InvariantCulture);

Hi, I'm trying to substract the hours of the time with the hours of the begining of an event, and print how many time is left. Can someone help me? //Preço Viagens $partida=$viagens['HoraPartida']; $horapartida = explode(":", $partida); echo $horapartida[0]; $horasistema = date("G"); //hora sistema $difhoras=$horasistema - $horapartida;

Hello all I am having problem with my attendance management system. The problem is when ever i log in as admin it does not show a log in time but when ever i log in as a user it is howing time in. And secondly the time in and tim …

Hi to all i just cant get the grasp of what im trying to do basically i'm making a script that will higlight a certain **data(Date /time)** in my table if data < 3 min of current time.. ex $data="March 12, 2013, 16:18"; $current_time="March 12, 2013, 16:20" if($data< 3min of …

I would like to make a program in which the user selects a time frame, for example if he selects from a DateTimePicker1 the time 7 (July), 17th, 2012 through DateTimePicker2 7 (July), 20th, 2012, and presses the button, a text will show up in a textbox from which he …

Hi All, I have an xml which I am reading in a date: <DateOfBirthUpdate> <DateOfBirth>1951-04-25</DateOfBirth> </DateOfBirthUpdate> My code reads this in as 25/4/1951 00:00:00 but I need to convert it back to it's original format of 1951-04-25 so it can be used in a soap message. dateOfBirthUpdate.DateOfBirth = Convert.ToDateTime(record.Element("DateOfBirthUpdate").Element("DateOfBirth").Value); inUpdate.DateOfBirthUpdate …

I have a time as a string saved as HoursMinutes example 1642 (16:42) and I tried to convert it to date as Hours:Minutes with following code: Dim dt As Date Dim s As String s = "1642" dt = CDate(Format(s, "00:00")) but the result is: 00:00 instead of 16:42 Any …

i wanna add date in my form.. so i do with my code like this $sql_updTenant = "UPDATE md_tenant SET modifieddt = '".date('Y-m-d H:i:s')."'"; and in my php.ini, i already change this: ; Defines the default timezone used by the date functions ;date.timezone = to this: ; Defines the default …

Hi, I've been playing about with native classes and looking to extend them - well just the DateTime class actually. I was hpong that there would be a way to avoid using a constructor, but I can't seem to figure out how to store a 'startup' timestamp, `u` without it. …

Hi, I need to fill a toolstripcombobox with dates. The values in the toolstripcombobox need to be sorted by date. The database field that I am pulling to fill this toolstripcombobox has the following fixed format: 201201, 201211. So, I first need to convert the retrieved values from YYYYMM to …

i'm trying to make a script to calculate the diference between two dates, but in minutes, the thing is that i need to remove from mysql database all the entries that has mora than 15 minutes on the database, i'm planing to run the script in background using the cron …

Hi I'm just learning the date() function. I'm trying create a `Daylight Savings` I used `$todayDate = date("D-m-d-Y-T-a");` because I am going to run it that day. For example: `Daylight Savings is on Sunday, November 4, 2012, 2:00am.` My issue is that once I run the code my answer is …

Hi guys, I'm sure that this would be an easy thing to do, but i'm away from c# for quite a long time. I need to compare two dates (only dd-MM-yyyy format) and show the result, but this result must be really accurate, meaning that it must make the calculation …

hello guys as you can see i have a method isdate with return type datetime and parameter string, what i wanted to do is to do is to check if inputdate is valid or not. may dateformat is these "MM/dd/yyyy" ex. if user1 input = "2/29/19" in method isdate the …

Hi guys, **I have this error :** Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most …

hi friends, i have two datetimepickers in a window form application.One datetimepicker is used to select date and second one is for time. Now i want to combine date from DTP1 and time from DTP2 and update the database with the selected combined datetime value using vb.net. Thankyou

anyone know whats the problem/reason with this codes? 1. calculation with fix time <?php date_default_timezone_set('UTC'); $deff = strtotime("20:00:00")-strtotime("19:00:00"); echo date('h:i', $deff ); OUTPUT = 01:00 //above was correct ?> 2.output should be in munite, but the output is 12:50 what's wrong with this code? date_default_timezone_set('UTC'); $deff = strtotime("20:00:00")-strtotime("19:10:00"); echo date('h:i', …

OK, Now that I know how to add minutes to a datetime field... I need to be able to take a specific date time as in NOW... Then add 30 days to it, and have record that date at 19:00:00 as an expiration date time I start by capturing the …

hi friends plz tell me how to add time which is in HH:MM:SS (in 24 hr format). i have a array of time stored. need to add those times and calculate total time...

Hello All Here is my problem : I have 3 variables 1. month 2. year 3. day all three of those variables have numeric values for example month = 04 year = 89 day = 17 I want to display it like this : 17 Apr 1989 Here is what …

Good Afternoon, I'm struggling with something that should be simple (where I have most trouble - simple things) Basically what I'm trying to do is when someone places an order on hold, I want to leave it on hold indefinitely unless someone else wants to place the same items on …

hi, I have a problem to convert string to Datetime format and insert into informix database.. my code: Dim strDate As String ="31/01/2012" i want convert into datetime and insert into database with format:"31/01/2012 12:30 PM" anyone can help me to fix this...

I have a CRON job set to run every hour (have to do it this often due to scheduling facilities on server) and one of the sections of the script is to check if a closing date for entries into an event is within 2 days and if so to …

Hi Everyone, I want to write a condition for Datetime to show gridview. The condition is that the gridview has to show data for updating datas in DB only from [B]Friday 5:00pm to Saturday 4:00PM[/B] How can I give this condition.I had tried various datetime methods but i cant figure …

I have a table which has a field ItemsReceived of type datetime. I have a grid view which has two columns. In first column i have to show the data from field ItemsReceived and in second column I have to show difference between Currenttime and date from ItemReceived. How can …

[CODE]<?php $myServer = "202.138.125.155"; $myUser = "micro_fms"; $myPass = "micro_fms*#$"; $myDB = "micro_fms"; //create an instance of the ADO connection object $conn = new COM("ADODB.Connection")or die("Cannot start ADO"); //define connection string, specify database driver $connStr = "PROVIDER='SQLOLEDB'; SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB; //Open the connection to the database $conn->open($connStr); //$table_name=$_GET['Device']; $table_data=$_GET['Data']; $data=(explode(",",$table_data)); $table_name=$data[0]; $speed=$data[1]; …

I need to get the difference of two date time picker values and convert it to int or float, And the next thing is from the date time picker i cant select the time from front end. Only i cant select is the time only. these the some code that …

hi, i need to subtract one date form the other and take the difference in minutes or seconds.. i'm getting the first date from the data base in 'Y-m-d H:i:s' format and second date is the current date (same format). and i want to know the difference between them in …

hi, i got a message board kit that connects to the computer (i talked about it here: [url]http://www.daniweb.com/software-development/vbnet/threads/379541[/url]) and now (i hope) its working. I want to make a code that when i press on a button its will send the correct hour & date and then its will update …

[CODE] objEffort.IssueDate = string.IsNullOrEmpty(txtDate.Text) ? (DateTime?)null : DateTime.ParseExact(txtDate.Text.Trim(), "dd/MM/yyyy", null); [/CODE] I want to pass "07/20/2011 12:10 PM" this format to database . Please Reply me how can i do this. It's bit urgent

I want to find difference in hours and minutes from two DateAndTimePicker controls. how can i do this.

Hi there all. i have made an application which sends an email to client. our mail server is in india. so while sending an email it shows indian date in email. is there any way i can do some code that will convert the indian date to US datetime automatically.