> Do you really need microsecond, or even day, resolution in your dates? I
wonder if it'd not be good enough to store the year as an integer.
Maybe 2 columns:
date_col type date = For dates post 4713BC. Set to NULL if ealier than
4713BC.
year_col type integer = Store the year from date_col
Then w
Ryan Wallace <[EMAIL PROTECTED]> writes:
> I am building an application which requires the storage of dates relating to
> the creation of archaeological items. The problem I am facing is that
> although most of the dates are working fine, some of the items were created
> before the beginning of rec
Hi all,
I am building an application which requires the storage of dates relating to
the creation of archaeological items. The problem I am facing is that
although most of the dates are working fine, some of the items were created
before the beginning of recorded history (4713 BC).
Does an
Hello,
I need to do the following select:
Number of days of month - weekends - holydays
So this query will return the number of days that people can work
Look that I have the holydays in one table, it's bellow:
CREATE TABLE holidays
(
id_holidays serial NOT NULL,
dt_holiday date,
holiday_d
