33 Solved Topics
Remove Filter  | |
 | 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 … |
| | 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() { …  |
 | 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? |
 | 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 … |
 | if (ts1.CompareTo(DateTime.Now) == -1 && ts2.CompareTo(DateTime.Now) == -1) { MessageBox.Show("...."); } the function asks for a object, i gave an object... |
| | 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 … |
| | 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. … |
 | 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 …  |
| | 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?  |
| | I need a simple script to echo current date 600 times once every second redirect it to a text file and follow the file as it grows using a tail command.  |
| | Hello all, Ive done some googling around, and cant find anything that explains why my date isnt being formatted to what i tell it. my code: dim date_now as date date_now = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") So for example if the date/time is February 11 2015, 4:44:23pm it would be formatted as: … |
| | 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 … |
| | Hi community, I have a problem with an application which makes use of a mysql database. I have a class which saves the fields of every record on the table. One of the columns is of type Datetime. Sometimes (!) I query this column and get results like with a … |
| | Hi Frendz, I have datetime field in database. now i want to filter out the record which are in today date using mysql query? |
 | This have been a problem to me for long now and I want to settle it once and for all. PHP and MySQL DateTime and date fields have been headache to me. Suppose I have fields ------Name--------------BirthDate--------LastTimeYouAte-- ------VARCHAR(255)------DATE-------------DATETIME-------- Now, When I do insert, How do I format PHP Date and … |
| | Hello All I'm converting an access database to MS SQL for a webapp and have a question if anyone knows how to do this. 4 fields [TimeReported] [TimeOff] [TimeOn] [TimeAssigned] Access only stored time, so date is incorrect. 1 Field stored date separately [Date] I would like to take each … |
 | I am still relatively new to Python and don't think I'm familiar/comfortable enough with my understanding of the datetime functions... I want to take just the current month from the datetime function so I can use the number to send the string of the month (ex, datetime would give me … |
 | Can anyone clear my concepts of IsDaylightSavingTime() function of DateTime in C#. I am really confused about it. I want to ask exactly what is the need and use of this function? Thanx |
| | Can anybody please explain me this expression? CONVERT(datetime, CONVERT(varchar, GETDATE(), 1) thanks. |
| | Column A (datetime) ----------------------- 2011-04-01 00:00:00.000 2011-04-01 00:00:00.000 2011-04-09 00:00:00.000 2011-04-01 00:00:00.000 2011-03-31 00:00:00.000 Column B (datetime) ----------------------- 2011-03-25 15:45:56.457 2011-03-25 15:52:37.933 2011-03-25 15:54:37.197 2011-03-25 16:05:30.023 2011-03-27 00:43:23.713 When i try to query the above record [CODE] Select * from table where A between '1900-01-01' and '2012-01-01' [/CODE] this work … |
| | hi, How do i check for time difference for eg: i have code like this [COLOR="Red"]If GetServerDateTime() < Format(Now, "MM/dd/yyyy hh:mm:ss tt") Then msgbox ("Invalid datetime") endif[/COLOR] i want to make it like if the time difference is within 2 min from the current time.... the application still can allowed … |
| | I have a datetimepicker which reads a date as dd-mm-yyyy. the sql im using(sql server 2008) is only reading mm-dd-yyyy. i am having a problem with changing the format of how the date is saved. i put a catch to the code and this came up System.Data.OleDb.OleDbException: Conversion failed when …  |
| | |
| | I'm trying to compare two DateTime objects, but I am receiving the following error. error C2664: 'System:: DateTime::Compare' : cannot convert parameter 1 from 'System:: DateTime ^' to 'System:: DateTime' I'm just trying to use the DateTime 'Compare' method to perform the check. Below is an example to illustrate what …  |
| | Hi all - I've created a form to create events, but I can't figure out how to insert the date of the event properly into mysql (I'm not interested in inserting the time the register will be created, as that would be timestamp). I've got the column set as datetime … |
| | hi im sorry if this isnt in the right forum but i cant seem to find any threads in this. i cant seem to create a datetime object in vb.net with datetime string that's in this format "hh:mm:ss tt MM/dd/yy". The error im getting says its not a recognisable string …  |
| | Hello all, I am trying to make a program in visual basic 2010 where the user enters hours minutes and seconds into text boxes and then the program will count down from that until its equal to 0 when a msgbox appears and says its finished. I was converting hour …  |
| | hi, i'm using phpmyadmin & would like to create an additional field in the following table. Field // Type Collation Attributes Null Default Extra Action user_id // int(10) first_name //varchar(20) last_name // varchar(40) email // varchar(80) pass // char(40) user_level //tinyint(1) active // char(32) registration_date// datetime the field would be … |
 | Hi all I have a table that has a datetime column. What I'm trying to do is select the time only like one does when selecting only the day or month from a date column (eg SELECT day(date)) Can anyone tell me how to get this right. Using the following …  |
| | Hi, I have a question regarding the date time in C#. I want to get the date and the time in two digit 4 as 08.45am 27/07/2010. How can I get it like this. thankxxxx  |
The End.