Обсуждение: Date Dimension

Поиск
Список
Период
Сортировка

Date Dimension

От
Chuma Ofole
Дата:
Hi Everybody,

I am using Pgadmin 4.Can someone tell me how to create and populate data in date dimension?

Thanks in advance!

Chuma

unsubscribe

От
"U. Brauchli (update)"
Дата:

Re: Date Dimension

От
Melvin Davidson
Дата:
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

and



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