我如何获得当前日期？

Question

I've done some researching, but I can't really find anything for the format that I'm wanting. Please go easy on me as this is my second day learning PHP and I'm working on a fairly large project to learn.

I have a SQL Database using the 'Date' type, which follows the yyyy-mm-dd format.

My current SQL statement does this,

$query = "INSERT INTO $tbl_name (Date, Amount) VALUES ('now()', '$Amount')";

However, this doesn't update the date, and all of my entries are showing 0000-00-00

I'm not sure what I'm doing wrong.

Answer 1

You can also define your table to use CURRENT_TIMESTAMP as default value:

CREATE TABLE `example` (
  `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `modified_at` DATETIME ON UPDATE CURRENT_TIMESTAMP
)

DATETIME can be used only from MySQL 5.6.5. In previous versions you need to use the TIMESTAMP type:

CREATE TABLE `example` (
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `modified_at` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)