1,105,402 Community Members

php function to gett me year-month-day-hour-min-sec

Member Avatar
hwoarang69
Posting Pro
572 posts since Feb 2012
Reputation Points: -4 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 9 [?]
 
0
 

i am using xammp for my database.
i have a col called "today_date" andy type "DATE".
in php i am using function "now()" to store todays date. the format is year-month-day.

now let say i have one more col called "today_date_time" and type "datetime".
is there a php function that can get me a date and time of today and format is year-month-day-hour-min-sec

Member Avatar
Zagga
Posting Pro in Training
438 posts since Dec 2009
Reputation Points: 46 [?]
Q&As Helped to Solve: 90 [?]
Skill Endorsements: 6 [?]
 
1
 

Is this what you mean?

putenv("TZ=Europe/London"); // Set to your timezone (server may be in a different zone).
$now_datetime = date("Y-m-d-H-i-s", time()); // eg. 2012-12-09-03-34-25
Member Avatar
hwoarang69
Posting Pro
572 posts since Feb 2012
Reputation Points: -4 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 9 [?]
 
0
 

i tryied this date('Y-m-d H:i:s',time()) but didnt worked. it does print
eg 2012-12-09 03:34:25. but i cant seem to store in database.

$sql = mysql_query("INSERT INTO item  ...
                   ,date('Y-m-d H:i:s',time()),...
Member Avatar
urtrivedi
Posting Virtuoso
1,898 posts since Dec 2008
Reputation Points: 249 [?]
Q&As Helped to Solve: 409 [?]
Skill Endorsements: 27 [?]
 
1
 

i will not use php ever, I will use mysql stuff to add time and date

insert into table1 (col1,col2,today_date,today_datetime) values ('col1value','col2value',current_date(),current_timestamp())
Member Avatar
hwoarang69
Posting Pro
572 posts since Feb 2012
Reputation Points: -4 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 9 [?]
 
0
 

error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'time())' at line 4

$sql = mysql_query("INSERT INTO item 
            (image_user_name, image_folder_name, main_category, sub_category, price, description, features, key_words, sold, item_add_date)
                        VALUES('$image_user_name_p', '$image_folder_name','$main_category_p','$sub_category_p',
                            '$price_p','$description_p','$feature_p','$key_word_p', '0' , date('Y-m-d H:i:s',time())") 
                            or die(mysql_error()); //date() //date,timestamp
Member Avatar
urtrivedi
Posting Virtuoso
1,898 posts since Dec 2008
Reputation Points: 249 [?]
Q&As Helped to Solve: 409 [?]
Skill Endorsements: 27 [?]
 
1
 

try without braces
current_date, current_timestamp

Member Avatar
broj1
Posting Virtuoso
1,576 posts since Jan 2011
Reputation Points: 220 [?]
Q&As Helped to Solve: 219 [?]
Skill Endorsements: 21 [?]
Featured
 
0
 

it does print eg 2012-12-09 03:34:25. but i cant seem to store in database

What is the format of the field you want to store the value into?

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'time())' at line 4

PHP functions can not be parsed within a double quoted string (as far as I know). Assign a value to a variable first and then use this variable in a query.

$temp_time = date('Y-m-d H:i:s',time());

$sql = mysql_query("INSERT INTO item
(image_user_name, image_folder_name, main_category, sub_category, price, description, features, key_words, sold, item_add_date)
VALUES('$image_user_name_p', '$image_folder_name','$main_category_p','$sub_category_p',
'$price_p','$description_p','$feature_p','$key_word_p', '0' , '$temp_time')")
or die(mysql_error()); //date() //date,timestamp
Member Avatar
urtrivedi
Posting Virtuoso
1,898 posts since Dec 2008
Reputation Points: 249 [?]
Q&As Helped to Solve: 409 [?]
Skill Endorsements: 27 [?]
 
0
 
You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article