Re: Date Dimension

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 <cofole(at)aol(dot)de> 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