MySQL date format
19 June 2003, 06:38 PM
#1
Scooby Regular
Thread Starter
Anyone know if you can store the date in MySQL in the "normal" format?
Currently it stores dates as YYYY-MM-DD, which is odd, and a particular pain when using the ASP date function.
Anyone any ideas, other than creating a function to read or store the standard format?
Currently it stores dates as YYYY-MM-DD, which is odd, and a particular pain when using the ASP date function.
Anyone any ideas, other than creating a function to read or store the standard format?
19 June 2003, 08:09 PM
#2
Scooby Regular
Join Date: Jan 2002
Posts: 667
Likes: 0
Received 0 Likes
on
0 Posts
Nope, I use MySQL with PHP and have functions to go from mysql date to unixtime and back. IIRC doesn't ASP use an even more annoying US format anyhow? (Hence various date bugs on this BBS 
)
)
19 June 2003, 11:07 PM
#3
Scooby Regular
Thread Starter
Never noticed any probs before Andy, just use date, or day(month), or now and it gives you the whole shebang 
Looks like I need to write a function for it then.
Looks like I need to write a function for it then.
20 June 2003, 08:31 AM
#4
Scooby Regular
Join Date: Oct 2000
Posts: 368
Likes: 0
Received 0 Likes
on
0 Posts
function getdate(epoch)
'converts unix epoch date to UK date / time format...
getdate = dateadd("s", epoch, #1970-01-01#)
end function
Dates in ASP depend on server locale. I've not had any problems with them, but then again I use either my own servers or Titan's, which are correctly set up for the UK.
'converts unix epoch date to UK date / time format...
getdate = dateadd("s", epoch, #1970-01-01#)
end function
Dates in ASP depend on server locale. I've not had any problems with them, but then again I use either my own servers or Titan's, which are correctly set up for the UK.
20 June 2003, 09:02 AM
#5
Scooby Regular
Thread Starter
Thats why I have also never had any probs then, all hosted with Titan
Cheers Ady, where to use it then? Presume that will read the date format from the db, then change it for displaying. I will also need an input function for adding the date as well.
Cheers Ady, where to use it then? Presume that will read the date format from the db, then change it for displaying. I will also need an input function for adding the date as well.
20 June 2003, 10:21 AM
#6
Scooby Regular
Join Date: Jan 2002
Posts: 667
Likes: 0
Received 0 Likes
on
0 Posts
if you're just inserting things as created into mysql you just do
insert into table (date) values(NOW()), which will give you now, however you've almost definitely got to edit the dates I suspect which means creating a function to do it unfortunately.
If you were using PHP:
insert into table (date) values(NOW()), which will give you now, however you've almost definitely got to edit the dates I suspect which means creating a function to do it unfortunately.
If you were using PHP:
Code:
/*
Calculate unixtime from a MySQL DATETIME
*/
function unixtime_from_mysql($mysql_date) {
if($mysql_date) {
list( $date, $time ) = split( " " , $mysql_date );
list( $year, $month, $day ) = split( "-" , $date );
list( $hour, $minute, $second ) = split( ":" , $time);
$unixtime = mktime( $hour , $minute , $second , $month , $day , $year );
return $unixtime;
} else {
return 0;
}
}
/*
Calculate a MySQL format date from unixtime
*/
function mysql_from_unixtime($unixtime) {
if($unixtime) {
return date("Y-m-d H:i:s",$unixtime);
} else {
return "0000-00-00 00:00:00";
}
}
20 June 2003, 07:20 PM
#7
Scooby Regular
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
how about simply...
temp = "2003-06-20"
mysqldate = Right(Date,4) & "-" & Mid(Date, 4,2) & "-" & Mid(Date, 7,2)
Wscript.echo mysqldate
AspDateFromDb = Right(temp,2) & "/" & Mid(Temp, 6,2) & "/" & Left(Temp ,4)
wscript.echo AspDateFromDb
temp = "2003-06-20"
mysqldate = Right(Date,4) & "-" & Mid(Date, 4,2) & "-" & Mid(Date, 7,2)
Wscript.echo mysqldate
AspDateFromDb = Right(temp,2) & "/" & Mid(Temp, 6,2) & "/" & Left(Temp ,4)
wscript.echo AspDateFromDb
Trending Topics
Thread
Thread Starter
Forum
Replies
Last Post