Is this what you want?
Click Tools Query Tool
CREATE TABLE has_date_col( some_date_info DATE);
INSERT INTO has_date_col
(some_date_info)
VALUES
('2017-06-01'),
('2017-06-08');
SELECT * FROM has_date_col;
Also RTFMhttps://www.postgresql.org/docs/9.6/static/datatype-datetime.html
andhttps://www.postgresql.org/docs/9.6/static/sql-createtable.html
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
On Wednesday, June 21, 2017, 6:15:45 PM EDT, Chuma Ofole <[email protected]> wrote:
Hi Everybody,
I am using Pgadmin 4.Can someone tell me how to create and populate data in
date dimension?
Thanks in advance!
Chuma
