we r trying to insert date from datetime picker into mssqlserver 2005 but it also enter defult time(00:00) with it in database. using we want only date... [CODE]& xyzdtp.value.date &[/CODE]

Member Avatar
Member Avatar
+0 forum 12

Windows 10 has a nice date and time display in his taskbar, it is becoming more difficult for me to see , unless I open it. Becoming older and older my eyes are not that ‘fresh’ as they used to be, so I decided to make a bigger time display that stays permanently on top of the screen. I’m not that proficient with WPF, but decided to give it a go and at last it worked! Try to do something you don’t fully understand and you will learn from.it! //Here is my code from the MainWindow.xaml file: Window x:Class="TimerWindow.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" …

Member Avatar
Member Avatar
+2 forum 2

How to change the format of: --> var enterDate = '2016-01-15'; // to 2016-01-15T00:00:00.0000000+08:00 with JS syntax? // I try these and none of these works out: 1) enterDate.format("yyyy-mm-ddT00:00:00.0000000+08:00"); console.log(enterDate); 2) enterDate.toLocaleFormat("%B %e, %Y %M:%S"); Thanks in advance.

Member Avatar
Member Avatar
+0 forum 1

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.

Member Avatar
Member Avatar
+0 forum 4

This code gets the data from the table to show in a table for the user using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Collections; using System.Collections.Generic; using System.Text; namespace Form { public class RelUse { public DateTime Date { get; set; } } public RelUse() { atribuiValores(row); } public RelUse(DataRow row) { assignValues(row); } protected void assignValues(DataRow row) { this.Date = Convert.ToDateTime(row["Date"]); } } It gets the date how it is in the database yyyy-mm-dd hh:mm:ss. Can I do some method in the DateTime to change the formatting of the date to dd/mm/yyyy hh:mm:ss

Member Avatar
Member Avatar
+0 forum 3

I'm currently working on a collection of sub-projects, one of which was a backup manager. I needed to be able to allow the user to specify a backup time and a repeat interval. After thinking about the solution, decided it would be best for the user to provide an Initial DateTime of the first occurance and how frequent they would like to repeat the event. This class can be used to help determaine Alarms, Reminders or anything that requires an event to be triggered at a certain time. >Fun and Good for Beginners It was good fun writing this wee …

Member Avatar
Member Avatar
+1 forum 2

Hello, I am trying to record a birthdate. I am looking for the right variable to do that. The only option in mysql database xampp is datetime: yyyy-mm-dd hh:mm:ss While I would like it to be: dd-mm-yyyy ? How? If I input the data dd-mm-yyyy will my database adapt to it?

Member Avatar
Member Avatar
+0 forum 1

Hi Guys, I'm using Python 2.7.3, How can I ask the user to enter "from datetime" & "to datetime" then plot the graph For eg. when user from datetime: 21/7/2014 0:00 to datetime: 22/7/2014 23:57 from datetime import datetime import matplotlib.pyplot as plt import matplotlib.dates as mdates x = [] y = [] t = [] fig = plt.figure() rect = fig.patch rect.set_facecolor('#31312e') readFile = open('data.txt', 'r') sepFile = readFile.read().split('\n') readFile.close() for idx, plotPair in enumerate(sepFile): if plotPair in '. ': # skip. or space continue if idx > 1: # to skip the first line xAndY = plotPair.split(',') time_string …

Member Avatar
Member Avatar
+0 forum 6

Hi, I'm new to vb and I need to record the time the user used a certain privilege and the time s/he finished using it. i used date/time picker but whenever i run the program, i can't edit the time. only the date. help please?

Member Avatar
Member Avatar
+0 forum 4

I have coded this today and wanted to find all the data inside my database which is start_time and end_time also date which is very easy for me to validate but when it comes to time... its really hard this is what I want to do. 1. check all the data 2. validate the time 2.1 when there is no time like the user entered insert into database 2.2 but where there is a time like that or in between earlier reserved time that should be an error well i have this code here and its almost done i know …

Member Avatar
Member Avatar
+0 forum 2

if (ts1.CompareTo(DateTime.Now) == -1 && ts2.CompareTo(DateTime.Now) == -1) { MessageBox.Show("...."); } the function asks for a object, i gave an object...

Member Avatar
Member Avatar
+0 forum 2

hello, i just want to find difference between two dates interms of days by getting dates as a user input. i tried getting user input using raw_input but it shows some erroe message. can anyone tell me the right coding for this one.urgent please...

Member Avatar
Member Avatar
+0 forum 1

Hello I am working on this code for a hotel reservation. so far I am stuck on the part which requests that fridays and saturdays be charged 150 instead of the 120 usual cost per night. I have dateTime variables for the arrival date and departure date and a timeSpan variable for the duration of the stay. my thought was to step through each day of the timeSpan variable and for each occurance of the DayOfWeek.Friday and DayOfWeek.Saturday I was going to add 30 dollars (the additional cost for a weekend night) to a variable weekendCost which i would then …

Member Avatar
Member Avatar
+0 forum 5

Hello. I'm trying to use SqlDataReader to return information from my database. It works fine until it comes to a datetime field. I'm getting an error saying: " Input string was not in a correct format." on the line where I'm declaring a variable to hold my field. Here is the line where the error is occuring: Dim waitDate As Date = reader.GetDateTime("WaitListDate") Can someone tell me what I'm doing wrong?

Member Avatar
Member Avatar
+0 forum 11

Hi all, First tutorial submission. The standardised strtotime() function really grinds my gears. I hate messing about with dates in different formats... so I mullered this little function up. It works perfectly - probably easier ways to do it, I don't know... I just include this function in my functions files and whenever I want to change a UK based human readable date to a timestamp... I run it through this; quick and simple! Hope you find it useful!

Member Avatar
Member Avatar
+1 forum 1

So you want to find out which day of the week you were born. Well at least some of us do. I actually wrote this program because my whole family was born on Sundays, and my friends didn't believe it! An oldie but goodie, moved from DeSmet C to Turbo C, to Pelles C, and now to Python.

Member Avatar
Member Avatar
+3 forum 2

hi, i want to store date time whan i click radio button(name login time)in mysql. if i click logout radio button it should store logout time. ples help me... php and mysql code ...

Member Avatar
Member Avatar
+0 forum 3

Hey Everyone, I have table called vdet_sa_archive and in that table there are so many fields and i want to access the data on datetime range. sample data in table starttime endtime 1 14-02-13 01:30:15.000000000 AM 14-02-13 02:01:57.000000000 AM 2 14-02-13 4:30:01.000000000 AM 14-02-13 5:30:01.000000000 AM 3 14-02-13 01:30:01.000000000 PM 14-02-13 01:45:01.000000000 PM So i want to access the data between 14-02-13 1:00:00 AM to 14-02-13 5:00:00 AM So how can i get this data i wrote like select count(*) from vdet_sa_archive where starttime >= TO_DATE('14/FEB/2013 01:00:00 AM', 'dd/mm/yyyy HH:MI:SS AM') and endtime<=TO_DATE('14/FEB/2013 04:00:00 AM', 'dd/mm/yyyy HH:MI:SS AM'); But its …

Member Avatar
Member Avatar
+0 forum 2

hi i am writing a report, it must have parameters ToDate and FromDate,now the thing is i did all that but it stllrespond with just headring no data. Please help what am i doing wrong

Member Avatar
Member Avatar
+0 forum 3

Hi , Can anyone tell how I will send the local time zone to the server and so that I can convert the unix time(coming from the database) to the local time and display it on the clients side using php (In short I dont want to use javascript when I display the time) This is how I saved the time to database: - **Javascript** var exp_day = $("#exp_day").val(); if ( (exp_day == 0) || (exp_day == "") ) { exp_day = 00; } else { exp_day= parseInt($("#exp_day").val()); } var exp_hrs = $("#exp_hrs").val(); if ( (exp_hrs == 0) || (exp_hrs …

Member Avatar
Member Avatar
+0 forum 1

hiii, i am executing the following stored procedure but having errors... create procedure check_returns @salesman varchar(10),@RCV10 int,@RCV09 int,@RCV15 int,@GPRS15 int,@RCV20 int,@RCV25FTT int,@RCV25 int,@RCV31 int,@RCV30 int,@RCV35 int,@RCV50 int,@RCV55 int,@SIM int,@VTOPSIM int,@VTOPBAL int,@THREEGSIM int, @ENTRYDATE datetime AS BEGIN if exists(select * from CardsIssued where salesman=@salesman and RCV10>@RCV10 AND RCV09>@RCV09 AND RCV15>@RCV15 AND GPRS15>@GPRS15 AND RCV20>@RCV20 AND RCV25FTT>@RCV25FTT AND RCV25>@RCV25 AND RCV31>@RCV31 AND RCV30>@RCV30 AND RCV35>@RCV35 AND RCV50>@RCV50 AND RCV55>@RCV55 AND SIM>@SIM AND VtopSim>@VTOPSIM AND VtopBal>@VTOPBAL AND ThreeGSim>@THREEGSIM and EntryDate=@ENTRYDATE ) BEGIN insert Cards_Sold values(@salesman,@RCV10,@RCV09,@RCV15,@GPRS15,@RCV20,@RCV25FTT,@RCV25,@RCV31,@RCV30,@RCV35,@RCV50,@RCV55,@SIM,@VTOPSIM,@VTOPBAL,@THREEGSIM,@EntryDate) END ELSE PRINT'CARDS RETURNED CANNOT BE GREATER THAN CARDS ISSUED' END the error coming is.... Msg 8114, Level …

Member Avatar
Member Avatar
+0 forum 3

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. I'm assuming this property is essential for the `reset()` method. Everything seems to work OK, as long as I supply a valid TimeZone. class diaDate extends DateTime{ private $u; public function __construct($time='now', $timezone='Europe/London') { parent::__construct($time, new DateTimeZone($timezone)); $this->u = $this->format('U'); } public function __toString() { return $this->format('Y-m-d H:i:s'); } public …

Member Avatar
Member Avatar
+1 forum 6

I have downloaded code library from http://jqueryui.com/download related to datetimepicker control to add to a text box in asp .NET web page (Without master page) , and it is working fine (ie. themes are also displayed fine ,as EXPECTED colors) But need to know the **correct sequence of calling the .css files and .js files** , as I didn't find the proper sequnce.Plus need to know **what essential files need to be copied to the development folder** from the download folder too, as I have copied almost all the files (Not good practice ) Code is below <%@ Page Language="C#" …

Member Avatar
Member Avatar
+0 forum 1

Hi all, I have a problem with the date in javascript.I have a date which is in string format Like this: 10/5/2012 6:00 PM and what i need to do is at 5:00 PM on date 10/5/2012, i need to add a class to the td. <table width="100%" border="0" id="datetime"> <tr> <td>Dates</td> </tr> <tr> <td>10/9/2012 6:00 PM</td> </tr> <tr> <td>10/9/2012 7:00 PM</td> </tr> <tr> <td>10/10/2012 8:00 PM</td> </tr> <tr> <td>10/15/2012 8:00 PM</td> </tr> </table>

Member Avatar
Member Avatar
+0 forum 2

Hi, How can i convert my column with timespan dataType (Eg: 04:04:45 ) to DateTime in HH:mm:ss format (Eg: 04:04:45)? Currently I can convert the column to datetime (Eg: 10/2/2012 4:04:45 AM) but I only want the time (Eg: 04:04:45 ). Can someone help me please...

Member Avatar
Member Avatar
+0 forum 8

Sorry people but I'm really struggling with this and I don't know why... but still. I have a stored unix timestamp. [a] I have the current timestamp not in unix format (YYYY-MM-DD HH:MM:SS) [b] I need to: 1) convert the current timestamp [b] into a unix timestamp 2) I need to take the stored timestamp away from the newly created timestamp 3) I need to add the converted timestamp onto the stored timestamp. This is for an uptime counter that uses days hours minutes and seconds, not %. Thanks :)

Member Avatar
Member Avatar
+0 forum 1

hi, i want to retrieve only the second field from system datetime..how can i do that??can anyone plz help me..thanks in advance

Member Avatar
Member Avatar
+0 forum 4

I try to filter my datagridview with a datetimepicker. When the datetime value is just date (eg.15/5/2010) everything work fine. But when there is also date and time value occurs conversion problem "conversion failed when converting date and/or time from character string". Iused also combobox populated with the dattime values but i confronted the same problem.. My goal is to calculate the average readings of a meter. Every next reading is equal to the previous one plus the last period consumption (energy meter). First I calculate the difference between the two readings (which correspond to the dates user choose from …

Member Avatar
Member Avatar
+0 forum 2

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 "try" part will fetch the data and return ex. if user1 input = "2/30/19" not valid "catch" part will fetch data and split the string "2","30","12" only "2/12" will be left, and format "MM/yy" and get the last day of that month (my date handler is textbox only to performed …

Member Avatar
Member Avatar
+0 forum 1

Hi, I have a table with a timedate collumn. I want to get the text of the article and its creation date, than to output them on my page. How can I just get only the date value from a query or php script manupulation?

Member Avatar
Member Avatar
+0 forum 4

The End.