my sql server is broken :( - GoFuckYourself.com

Marcus · 10-24-2001, 06:14 PM

I keep using the getdate() function but I still don't have a date.

what should I do?

Speedy26 · 10-24-2001, 06:43 PM

try adultfriendfinder

big perm · 10-24-2001, 06:48 PM

Naughty · 10-24-2001, 06:54 PM

Quote:

Originally posted by Speedy26:
try adultfriendfinder

Too funny

------------------

- the Official TGP2 Counter --> signup now for realtime stats, toplists and more...!
- Submit Your Galleries Here to The Naughty Daily
- EraserCash - $35/signup, unique commissionprogram

FADE19 · 10-24-2001, 08:03 PM

I would do it in the script and then submit along with whatever else you are uploading to the DB, I am assuming because you are using SQL server it is Micoshit sooo...in ASP do this:

inpu typ="text" NAME="time" value="<4=now()4"

replace the 4's with percentage signs...this is just a temp fix....I have been doing PHP for awhile so my ASP is a little rusty

[This message has been edited by FADE19 (edited 10-24-2001).]

awechen · 10-25-2001, 05:30 AM

Quote:

Originally posted by Marcus:
I keep using the getdate() function but I still don't have a date.

what should I do?

ok u using php ?
if yes ..
getdate returns an associative array containing the date information of the timestamp, or the current local time.
u u need the system time now !
which format u need ?

or u need the timestamp ?
or u need to convert the timestamp to a 'real' time ?

------------------
"Shock your systemadministration! Read manual-pages!"

pipp · 10-25-2001, 06:16 AM

setlocale ("LC_ALL");
#It the server is in another time zone
$time_offset="+0";
$date_format= "%A %d %b, T. %H:%M";

$sql= "SELECT UNIX_TIMESTAMP(insertedDate) as insDate";

$date = strftime($date_format,$myrow["insDate"]);

Robert · 10-25-2001, 06:18 AM

Quote:

Originally posted by Speedy26:
try adultfriendfinder

awechen · 10-25-2001, 11:22 AM

Quote:

Originally posted by pipp:
[B]
$sql= "SELECT UNIX_TIMESTAMP(insertedDate) as insDate";

heeh this suxx is it a remote host sql

)

[B]

------------------
"Shock your systemadministration! Read manual-pages!"

10-24-2001, 06:14 PM	#1
Marcus Confirmed User Industry Role: Join Date: Jul 2001 Posts: 3,472	my sql server is broken :( I keep using the getdate() function but I still don't have a date. what should I do?

10-24-2001, 06:43 PM	#2
Speedy26 Confirmed User Join Date: Apr 2001 Location: MI Posts: 950	try adultfriendfinder

10-24-2001, 06:48 PM	#3
big perm Registered User Join Date: Oct 2001 Location: dirty jersey Posts: 37

10-24-2001, 08:03 PM	#5
FADE19 Snow's Parole Officer Join Date: Sep 2001 Location: mud hut next to Bin Laden's Posts: 1,161	I would do it in the script and then submit along with whatever else you are uploading to the DB, I am assuming because you are using SQL server it is Micoshit sooo...in ASP do this: inpu typ="text" NAME="time" value="<4=now()4" replace the 4's with percentage signs...this is just a temp fix....I have been doing PHP for awhile so my ASP is a little rusty [This message has been edited by FADE19 (edited 10-24-2001).]

10-25-2001, 06:16 AM	#7
pipp Confirmed User Join Date: Oct 2001 Location: Where the sun don't shine Posts: 1,185	setlocale ("LC_ALL"); #It the server is in another time zone $time_offset="+0"; $date_format= "%A %d %b, T. %H:%M"; $sql= "SELECT UNIX_TIMESTAMP(insertedDate) as insDate"; $date = strftime($date_format,$myrow["insDate"]);