[CrazyTn]

I have tried GREATEST, but it came out with an error.

I have a time clock table.
1. date - date
2. time - time with out time zone
3. punch_in - boolean

SELECT MAX(GREATEST( MAX(date),MAX(time))) FROM timeclock;

I get an error:
ERROR: GREATEST/LEAST could not convert type time without time zone to date
SQL state: 42846

I have also tried

SELECT MAX(date), MAX(time) FROM timeclock;
But that did not give me the right result.

I need the highest date, and the highest time for that date, but it just gives me the max date, and the max time.

[CrazyTn]

Got it.

SELECT MAX(time), date, punch_in FROM punchin WHERE date=(select MAX(date) FROM punchin) GROUP BY date, punch_in;

[loquin]

BTW. Using DATE and TIME as column names is a poor practice (They are reserved words in most database server or programming language...)

Second; why not combine the date and time in ONE field? You can easily separate the date/time as needed for display, and it's easier to perform date 'arithmetic' with a single field.

[CrazyTn]

Originally Posted by loquin

BTW. Using DATE and TIME as column names is a poor practice (They are reserved words in most database server or programming language...)

Second; why not combine the date and time in ONE field? You can easily separate the date/time as needed for display, and it's easier to perform date 'arithmetic' with a single field.

This was one of the first table I made when I first started programming. Kind of funny to see old codes from back then. Also tells me how much I have improved.

I am going to combine the two columns, but would need to fix up a lot of codes. Initially I didn't know that the time was saved as part of the Date type, so that was why I made two columns.

Thanks for the advice