Home > mailing lists

Re: Date Dimension - Mailing list pgadmin-support

From	Melvin Davidson
Subject	Re: Date Dimension
Date	June 22, 2017 05:41:54
Msg-id	1737793079.4854154.1498088515013@mail.yahoo.com Whole thread Raw
In response to	Date Dimension (Chuma Ofole <cofole@aol.de>)
List	pgadmin-support

Tree view

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 RTFM
https://www.postgresql.org/docs/9.6/static/datatype-datetime.html

and
https://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@aol.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

pgadmin-support by date:

From: marcelo
Date: 22 June 2017, 05:12:13
Subject: unsubscribe

From: Roland Kaschek
Date: 22 June 2017, 07:11:07
Subject: unsubscribe

Re: Date Dimension - Mailing list pgadmin-support

Previous

Next