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

Поиск

Рассылки

Список Везде pgsql-general pgsql-hackers buildfarm-members pgadmin-hackers pgadmin-support pgsql-admin pgsql-advocacy pgsql-announce pgsql-benchmarks pgsql-bugs pgsql-chat pgsql-cluster-hackers pgsql-committers pgsql-cygwin pgsql-docs pgsql-hackers-pitr pgsql-hackers-win32 pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-patches pgsql-performance pgsql-php pgsql-pkg-debian pgsql-pkg-yum pgsql-ports pgsql-rrreviewers pgsql-ru-general pgsql-sql pgsql-students pgsql-testers pgsql-translators pgsql-www psycopg

Период Все Вчера Неделя Месяц Полгода Год

Сортировка По дате, новые По дате, старые По релевантности

Искать

Date Dimension

От

Chuma Ofole

Дата:

22 июня 2017 г., 01:13:47

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)"

Дата:

22 июня 2017 г., 01:44:07

Re: Date Dimension

От

Melvin Davidson

Дата:

22 июня 2017 г., 02:41:54

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