Date Help

[Danny620]

wot is the php function to insert a date into the db like 2009-11-23 17:55:17 or sql

[cags]

When you say a date do you mean the current date/time? PHP can generate it like so...

 

echo date("Y-m-d H:i:s");

[ShadowIce]

Here's a more precise version:

 

<?php echo date('l, F jS Y h:i:s A'); ?>

[cags]

Here's a more precise version:

 

<?php echo date('l, F jS Y h:i:s A'); ?>

How is that a more precise way of creating the format "2009-11-23 17:55:17"?

[ShadowIce]

B/c it shows: Monday, November 23 2009 12:42 PM

[PFMaBiSmAd]

The question that was asked concerns a specific format, not the format you posted. The format you came up with is also unusable for direct database operations and takes more storage space in a database.

[Danny620]

thanks that worked how can i put display it as like tue 21 2009 12:11 PM

[cags]

date 

[ShadowIce]

FAIL, cags. -.-

 

Here danny, do this:

 

<?php echo date('D F jS Y h:i:s A'); ?>

[cags]

Erm, no. If anybody failed, that would be you. Again. Since the correct way of outputting what the OP asked for is...

 

echo date("D d Y h:i A");

... with the possible substitution of j for d, since it's impossible to tell from the value provided. But the point is, what's the point in us explaining every single format when theres a perfectly good manual that does it for us. It's not even like you can say the example in the manual is too complicated (as it is with some topics) since it's one of the simplest things on the site to understand.

[ShadowIce]

Um. no it would not. He said he wanted Mon November 23rd 2009 1:03 PM

 

and thats what i gave him.

 

period.

[PFMaBiSmAd]

ShadowIce, are you even reading the questions in the threads? You have recently replied in three threads other than your own and in each one you have posted information that does not match the question that has been asked.

[cags]

Um. no it would not. He said he wanted Mon November 23rd 2009 1:03 PM

 

and thats what i gave him.

 

period.

No, the OP didn't mention the month.

 

thanks that worked how can i put display it as like tue 21 2009 12:11 PM

Which is something that would have been very easy to check before your oh so intelligent retort.

 

period.

[ShadowIce]

O boy. ONE SMALL mistake. we're all human -.-

 

<?php echo date('D jS Y h:i:s A'); ?>

 

Fixed.. -.-

 

period

[cags]

[ot]They also didn't mention seconds or a suffix for the day. So I guess thats THREE SMALL mistakes. But nevermind. To be honest I don't really care and wouldn't normally have even mentioned it. Your the one that brought the attidute with your "FAIL" statement. Regardless, thats enough random shit in this thread.[/ot]