Skip to content

Latest commit

 

History

History
40 lines (29 loc) · 1.23 KB

README.md

File metadata and controls

40 lines (29 loc) · 1.23 KB

About

This project shows how to retrieve and show dates based on local time, while saving them normalized as UTC in the database.

Refer to the index.php file/page to find the main extracts of code and explanations on the two possible ways to achieve this purpose:

  • Normalizing dates to UTC with aid of the js datetime library 'dayjs'.
  • Normalizing dates to UTC without use of any external JS datetime library.

Installation

  1. Download the project from the repository.
git clone https://github.com/gaadeveloper/php-normalizing-dates-to-utc.git
  1. Create a new PostgreSQL database on your favorite database administration tool, and create the table 'dates' in this newly-created database running the following DDL code on a new SQL script:
-- public.dates definition
-- Drop table
-- DROP TABLE public.dates;
CREATE TABLE public.dates (
	date timestamptz NULL
);
  1. Create a file DbEnv.php inside the 'public' folder, paste the following code and change the environment data to the right database connection data in your case.
<?php

class DbEnv {
    public const HOST = 'postgres';
    public const DB = 'your_db_name';
    public const USER = 'your_user_name';
    public const PASSWORD = 'your_password_name';
}