[datetime] Forum Topics

I need to add dynamic timestamp with the attachment file test.dat as (test_currentDateTime.dat) sample code which I need to modify: <node name="testEmail" type="emailoutput" subject="this is a test mail with an attachment" xsl="&XSLPATH;test.xsl" outputType="text/plain" > <attachment type="text/plain" name="test.dat"/> </node> How can this be done in the attachment tag that is inside …

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.

Hi, I am getting the following error and I cannot understand why. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Before i try and insert the data into the database I print it out and this is what i get: **09/04/2012 00:00:00** The code below is …

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 All, I have an image upload that works for my requirements - But what I am unable to figure out is how to rename the image to the datatime stamp and to keep the file extension .jpg / .png / .gif / .jpeg etc I have a variable $datetime …

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...

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 …

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 …

I am trying to figure out the best way to figure out "age" of a particular item. I currently have fields in a mySQL databases that are stored as datetime formats and I need to display (in PHP) the relative age of those dates in terms of years, months, and …

For my new code that I'm developing, I have a text box where a user will type in a date as follows: [B]MM/DD/YYYY (e.g. 05/19/2011)[/B] This date then needs to be converted and inserted into a date/time field on a mySQL database. I've been trying to play around with this …

This code determines if datetime object represent first workday of month, but it does not consider the special days like New Year (this year weekend but last year Friday). Reaction to Basic efforts in: [url]http://www.daniweb.com/software-development/legacy-and-other-languages/threads/362098[/url] There algorithm idea given by [URL="http://www.daniweb.com/members/jonkiparsky/775324"]jon.kiparsky[/URL] based docstring says 'workday' when it should be 'weekday': …

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

One part of my program requires that the user enters a date and this date is then checked against each product in the dictionary to see if the date the product arrived plus its shelf life causes the product to expire before or after the date entered by the user. …

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 …

Hi, At the moment I am pulling a record from the database which is in datetime format. Could someone please tell me how I can modify this to just display the time and exclude the date? Many thanks for any help. [CODE]<?php $time = mysql_query("SELECT * FROM gps WHERE imei …

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 …

Could I select a datetime record using date only? I need to show rows containing a particular date. I'm thinking to separate it into two column instead if I couldn't select only date from a datetime.

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, in my windows form application Im using a microsoft report to generate receipts that show amounts, dates and userId's for those that have taken the payments. What I need to do firstly is where the userId's are displayed currently (as a foreign key) i'd like to show instead the …

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 …