Is it possible to change ASP's date function to a MySQL compliant (ie. year first; 2003/8/17) style without a lot of code?
Maybe I'm mis-guided. I have a website built in ASP and using MS SQL. I'm converting it all to MySQL, but I'd rather not have to rewrite all the instances where I do something like this...
ASP:
Code:
Query = "SELECT SUM(Total) AS Totals FROM orders WHERE create_date BETWEEN '" & date & "' AND NOW()"
Results in: Code:
now() = dd/mm/yy
mysql datetime = yyyymmdd
i'm a designer using dreamweavers asp coding / insert statements, but i cant get mysql to take the date in the right order....
this is the code im trying to use to insert a date to mysql db:
dim myquery
dim datew
datew = formatdatetime(date())
myquery = "INSERT INTO article (date) VALUES ('" & datew & "')"
this inserts a date but its always "0000-00-00", i want to get the actual date and add it to the table.
having issues submitting dates to a mysql db, ive converted the database from access to mysql and im having issues submitting dates. this is what i have when submitting to access
Code:
I am storing dates in a mySql database in the format yyyy-mm-dd. Now, I have set up so that this field is insert by a form.
It isn't very user friendly to have to type yyyy-mm-dd, how can I set up so that the user can enter format dd/mm/yyyy and it will automatically insert into the database as yyyy-mm-dd? I am using Dreamweaver MX 2004 and ASP.
I have all of the dates I use in my tables stored as date in the YYYY/MM/DD format, with the columns set to DATE.
When I do any queries on the database (not usinf ASP) I get YYYY/MM/DD format returned.
When I do a recordset("datefield") ASP request I get D/M/YYYY returned. I have not asked anything to convert it, I have no idea where it is getting converted. It is a real pain, as I need to copy these dates through out the table, and they are getting returned in the wrong format.
I found some script that converts ASP to MySQL. Now I need to reverse that process.MySQL Order_Date is the field I need to convert.I have a select list for order nunber - 'order date Where order date = MYSQL date stored in db.Sounds simple enough, but is very difficult so far to implement.
View Replies View RelatedI am trying to compare a date in MYSQL field with the system date -
today = date()
sqlchk = "SELECT COUNT(*) FROM fib_note WHERE fib_note_actdate =< " &"'" &today &"'" & " AND fib_note_actdone = 0"
Set objRS = objConn.Execute(sqlchk)
It is freakin out as the date in the DB is YYYY-MM-DD where as the date from date() is MM/DD/YYYY how can I get around this?
How do I convert 12/15/1985 to 15 December 1985 format using classic ASP?
View Replies View RelatedI'm trying to display activities completed on the previous day.
I tried =Date() -1 but... I'm getting both the previous day's
and current day's completed activities.... I'm using Access/
MS-SQLServer... which I'm newbie with... I'm an Oracle type.
I would need a function in asp wich will show date like at www.sitepoint.com at last forum post's. It means function would look like:
function(date)
and print for example this:
before 2h & 14 minutes.
I want to insert the current date into a form field as a default text.However, when I use <%=Date()%> it insets the date in the format 6/9/2004.How can I get it to insert the date in UK format (dd/mm/yyyy) using leading 0's for single numbers, so I end up with 09/06/2004?
View Replies View RelatedI have a table in which i have a field dtmdatetime as date/time data type.I want to fetch the records of current date,since the filed in table is in date/time format,it doesnot compare the date i entered,bcoz i enter only the date not time.
View Replies View Relateddoes anyone know how to put the 'date()' into a text box.
View Replies View RelatedIs it possible to find out the date of a Monday from a given date. Here are to examples
The date is Thursday 5th of June the function would return Monday 2nd June. The date is Friday 13th June the function would return Monday 9th June.
i have a to find out if this can be done in a easier way . i am trying to add 5 years to the current date
so today is 08/11/2006
if i add 5 years
i want it to be 08/11/2011. so what i did was from current date get the mm/dd/yyyy seperately then added 5 to the yyyy . and then did a concat and got 08/11/2011 . is there a easier way of adding years to the current date.
How do I convert 12/15/1985 to 15 December 1985 format using classic ASP?
View Replies View Relatedhow do i display only the day using the date function.
View Replies View RelatedI need to put a date function into a textbox. The function is <%=date>
View Replies View RelatedAny function on ASP to format date on dd/mm/yyyy?
The format (VB) function does not work on ASP ?
Is there a way to output a date in latin american format?
You know the day first, the month second and the year last.
If I want a message to show on the 3rd Friday evening and Saturday early morning of each month, is there a better way than the code that I use...
aztime = dateadd("h",-2,now())
If (day(aztime) => 14 and day(aztime) =< 21) and ((varDayOfTheWeek = 6 and dhour => 15) or (varDayOfTheWeek = 7 and dhour =< 2)) then
my message here
end if
The only month it would fail in 2008 would be June, so I was hoping there is code that would just deal with the 3rd Friday or Saturday of the month.
is there a way to 'force' ASP date function to return date in a given format; I mean, my need is to force 'date()' function to give me system date in italian format instead of english (O.S. is in english as well as locale settings for IIS anonymous user); is there a directive or something similar to put in ASP code?
View Replies View RelatedIm working on a Year(Date) function right now, the output of that function is this "2005", my question is how can i change the format into this "05"
Function: Year(Date)
Output: 2005
Needed Output: 05
Does anyone have a date validation function that checks if the day month and year are all valid. For instance, if it's a non leap year and the date 29th Feb is entered?
View Replies View Relatedi need to retrive record form database for a particular DATE and particular name i have to pass date and name thro "form" then i have to display that particular record . how to proceed.
View Replies View Relatedi want to display the Week start Date & End Date with week number when i use:
select datepart(date,Pur_Date),sum(Amt) from Purchase where Pur_Date
between '01/01/2004' and '14/01/2004 ' group by
datepart(date,Pur_Date)
result should be displayed as:
week start date end date SumAmt
1 01/01/2004 07/01/2004 1000
2 08/01/2004 14/01/2004 20000
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
What's the difference between private and public functions in ASP? When should I use either?
I am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.
this is the send message code ....
i'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
View Replies View Relatedsql = "UPDATE Marknad SET" _
& " Typ ='" & Typ & "'" _
& ", Modell ='" & Modell & "'" _
& ", Arsmodell ='" & Arsmodell & "'" _
& ", Beskrivning ='" & Beskrivning & "'" _
& ", Stad ='" & Stad & "'" _
& ", Prisidé ='" & Priside & "'" _
& ", Fornamn ='" & Fornamn & "'" _
& ", Efternamn ='" & Efternamn & "'" _
& ", Telefon ='" & Telefon & "'" _
& ", Epost ='" & Epost & "'" _
& ", Datum ='" & Datum & "'" _
& " WHERE (((Marknad.Annonsnr)=" & Request.QueryString("id") & "))"
DatabaseConnection.Execute sql
---
Above does work as I want it to do BUT it inserts 1/8/2006 instead of 8/1/2006 as it should!
The best thing would be to exclude the date from updating at all, but when taking away the line:
& ", Datum ='" & Datum & "'" _
It gives an error... how do I solve this?
I forgot, you might want to see this:
Datum = date
In my page i have two combobox. one for year and one for week numbers.Now my prob is
1.when i select a year from combo box 1, second combox box will display the number of weeks in that year.eg if i select 2005 it display me list from 1 to 53 as there are 53 weeks in 2005.
2.when i select a weeknumber from combobox 2 and press submit button it ll display start date and end date of entered week.