Hi,
Just looking at your "ads"."ad_creation_time", Facebook provide a full timestamp for this, but you're only storing the date. Is there a reason for that? Our use-case is "ads in last 24hrs", but this becomes inaccurate unless we stick to midnight to midnight.
I assume this is also UTC, though a date field doesn't include that information in a way a timestamp would.
Hi,
Just looking at your
"ads"."ad_creation_time", Facebook provide a full timestamp for this, but you're only storing the date. Is there a reason for that? Our use-case is "ads in last 24hrs", but this becomes inaccurate unless we stick to midnight to midnight.I assume this is also UTC, though a date field doesn't include that information in a way a timestamp would.