On 1 July 2013 17:47, Pavel Stehule <[email protected]> wrote: > 2013/6/29 Pavel Stehule <[email protected]>: >> long time I am thinking about simple function for creating date or >> timestamp values based on numeric types without necessity to create >> format string. >> >> What do you think about this idea? > I found so same idea was discussed three years ago > > http://www.postgresql.org/message-id/[email protected] >
I suggested something similar also: http://www.postgresql.org/message-id/[email protected] The thread I linked died off without reaching a consensus about what the functions ought to be named, although Josh and Robert were generally supportive of the idea. The function signatures I have been using in my own C functions are: * date(year int, month int, day int) returns date * datetime(year int, month int, day int, hour int, minute int, second int) returns timestamp Cheers, BJ -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
