I am trying to do an INSERT using the Now() function to populate a MySQL DateTime field. It is giving me the following error:
Incorrect datetime value: ‘11/20/2005 4:56:39 PM’ for Column ‘DateAdded’ at row 1.
The SQL works if I remove the DateAdded part so I assume the SQL statement is good. The reading I have done on MySQL shows examples using the Now() function inserting into different date/time MySQL data types so I don’t understand why my SQL is not working. I am trying to use the DateTime data type… basically, I want to keep as accurate of a date time as possible.....
I have a small (still) SQL database, which I am trying to query from an ASP page.
The field I am querying is of DATETIME data type, and is populated automatically using the GetDate() function as a default value.
When I try and search on this field, using a date/time in the format dd/mm/yyyy hh:mm:ss as the search criteria, it fails with the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Can anyone tell me why this is? Surely if I am passing a value in the correct format for the data stored in the field it should work? Or am I missing something.
I have a time field that starts at 00:00 through to 23:59 problem is the list is too long. I would like to have 2 dropdown fields HOURS & MINUTES that join together when the form is submitted and enters the time into the SQL db.
I have a few date fields on my form. The backend is SQL and the fields are set to smalldatetime. Adding records into these fields is not a problem. This is my code:
if Request.form("ScheduledTrainingDates") = "" then else objRS("ScheduledTrainingDates")=Request.form("ScheduledTrainingDates") end if
The problem is updating the records when I got to edit them. Let's say I have a value in for ScheduledTrainingDates textbox, and I want to clear the value and leave it blank and save it to the database. How do I do this?
suggest the correct way to store the date & time in SQL Server? I want to store the date and time a record was created. What should the field type be in SQL Server? How can I insert the current date/time into the table using SQL? I used to have date/time field type in access and use the following code
How does one return records in a recordset based on a time/date field. If todays date is 8/25/04, how could i return all those records from 8/25/04. Mind you, i have long date format ex. "8/25/2004 4:46:45 pm"
I dont want to user a form for this i simply just want these time- sensative records to be returned in the recordset .
I am designing a page in ASP and using MSSQL for the database. I want to use an if statement saying that if the field is empty, display something, else display something else.
However when i write:
Code:
If rsBoxEdit.Fields.Item("bFinishTime").Value = "" Then response.write("Edit Finish Time") Else response.write("Finish Time Already has a Value") End If
It say "Finish Time Already has a Value" when the field is blank.
The database saud the field is <NULL> if this helps and the field type is set to datetime.
Also if i put
Code:
If rsBoxEdit.Fields.Item("bFinishTime").Value <> "" Then response.write("Edit Finish Time") Else response.write("Finish Time Already has a Value") End If
I am calling a recordset from sql which happens to contain one column that is a datetime in the format: DD/MM/YYYY HH:MM:SS. So when I call that column from the db, it displays in the same format within my page.
However, I would like to be able to display the datetime as part of my recordset, but in a more aesthetically pleasing format (i.e: Sunday 1st May 2000, 7.23PM)
I have tried using the formatdatetime() function along with my rs, but this causes syntax errors. I know this is probably dead simple, but I don't get it!
I am using mysql as my database and which to use a datetime field, for both displaying the data and time and using it to sort the recordsets.
And although when you look at the Db it shows the data and time like this
yyyy-mm-dd hh:mm:ss
however if you simply display the field it displays like this
mm/dd/yyyy hh:mm:ss am (or pm)
I want to sort the data out so that it displays dd/mm/yyyy and there is no time, i can do this but wanted to know if there is a better way of doing it
My problems being I first have to work out if the date is below 10 then us a split function according, then the same with the month, then i have to use a massive if statement, to get it to display in words, and then I have to us the queries before so i can split the year, even if i use to fields in the db to store time and date i would still have the same problems, what is the best way to do this, Plus i may have more than one record to do, will this make a big different in processing my page if i say have 20 records to do.
and just to make sure is the timedate field suitable to sort my record sets out.
In one of my asp webpage,i am fetching the data from a XML file and which indeed is fetching data from mySql database.
Now the date time format i am getting in from XML is "Wednesday, October 24, 2007, 2:03:42 PM" and when i display that time in my asp webpage then it shows like "Wed, 24 Oct 2007 19:03:42 +0000"
I'm trying to isolate just the m/d/yyyy part of a datetime string like below. Can someone tell me why my string modification fails on some dates? I thought byb basing my code on where the blank space between the date and time would work. my code works on some dates that are single digit days and months.
This is part of an expense reporting application that I'm trying to recreate for a client. Client logs in and is shown a date. The date shown lets them know that they are entering info for the month after their last report (which is why we can't use Now(). The months have to be entered sequentially.This part is working fine.
I have a hidden field that holds the same date variable that I need inserted back into the same db. When they submit the form, they get a results page telling them everything went through. Everything is being inserted correctly to the database except for the datetime. It gets inserted incorrectly like this 0000-00-00 00:00:00. Meaning, it's zeroed out everytime even though the hidden field is pulling the date correctly.
how can i only display the hour / minute portion when i do (timestamp2 - timestamp1) in asp. When i display in asp, it gives me some funky number, probably it is the representation of timestamp value. It works in query analyzer, it gives me some date but the time is write though.
need to subtract one date from another to show how long a user was logger in for. i.e.
<%=(rsDriverLogin.Fields.Item("OFF_DATE").Value)%> minus <%=(rsDriverLogin.Fields.Item("ON_DATE").Value)%>
The values in the sql OFF_DATE and ON_DATE fields are stored as 13/06/2006 19:01:28 . Can either be done on the ASP page or in the db itself, doesn't matter which.
I am trying to use the datetime function. I am using Access as my backend database if you are wondering. I am building a program where someone can keep track of the software in our department and she wanted it to be able to email her when the software has been checked out for over 7 days. How to do this or where I begin? I am not too familiar with how one would add to dates in ASP.
i want to query the datetime field. need some guidance. Intention is to "Select * ...... Where datetime > 1st Jan 2006 and datetime < 31st Jan 2006" . My datetime is in "mm/dd/yyyy HH:MI: SS" . i understand that i can't put the query as in "where datetime => '01/01/2006' and datetime <= '01/31/2006'
i need to convert it to varchar as in "where convert(datetime, convert(varchar(10)...". Am i right ? Any other way to achieve that? What will be the correct query ?
I am trying to use the datetime function. I am using Access as my backend database if you are wondering. I am building a program where someone can keep track of the software in our department and she wanted it to be able to email her when the software has been checked out for over 7 days. how to do this or where I begin? I am not too familiar with how one would add to dates in ASP.
I have a date/time field, and I have an int field. When the user submits the form, I want to do date/time field - int field. I want to CAST the int field to a hour / minute field. Is that possible? For example: (4/7/2006 12:13:15 PM - x/x/xxxx xx:15 (min):xx Is there a better way to do this besides this?