Tagged Questions
0
votes
1answer
77 views
MS ACCESS: sql query not showing results expected [closed]
I'm having a little problem.
In my Access DB, I have a table named customers.
In this table I have a field DateEntered that is set to short text data type.
I am trying to run a query to pull all ...
3
votes
1answer
148 views
Retrieving queries when the hour of starting timestamp is less than the hour of ending timestamp
I have a CTE-based query in which I retrieve hourly intervals between two given timestamps. My query works as following:
Getting start and end datetimes (let's say 07-13-2011 10:21:09 and 07-31-2011 ...
2
votes
3answers
380 views
SQL Server dates - can I get date and hour?
In SQL Server, can I do the equivalent of to_char(date_field, 'YYYY-MM-DD:HH24') in Oracle to get 2012-01-30:23?
1
vote
1answer
516 views
Decode query truncates a date
I am not sure if I am looking at this problem the right way: I have a query like this on an Oracle database
SELECT
DECODE(
TO_CHAR(MIN(DATE), 'YYYYMMDD')
, ''
, NULL
...
2
votes
1answer
2k views
Compare a date and a timestamp with time zone with now() in the same query?
I have multiple database servers I'm querying with a query that compares an expiration column with now(). The problem is that one of the servers' expiration column is a timestamp with time zone, and ...
7
votes
3answers
1k views
Storing date as integer (numeric), what are the advantages
Question 1
I am working with a system where date is stored as integer (actual numeric(8,0)) and I have noticed that other systems also store date as int such as cisco in this thread. Example
...
