The date-format tag has no wiki summary.
2
votes
1answer
54 views
Load different date formats in mysql
I have a date field in my datafile which I am trying to load in MySQL, but the date field is in dd-mon-yy format and MySQL only understands YYYY-MM-DD.
Is there a way by which I can load DD-MON-YY ...
0
votes
3answers
60 views
SQL Server 2000 dateformat permanent change
I am using SQL Server 2000 for an old system web site. I've just hit an issue that is going to cause me endless hassles down the road.
When I installed the server on my local system I took all the ...
1
vote
1answer
87 views
Setting DATEFIRST to 6
I would like to set FIRSTDATE to 6 (ie: saturday), i have read that to change it parmanently i could set the default language of the login to one of an existing language from the sys.syslanguages and ...
0
votes
1answer
145 views
How to get only month from MySQL date/time?
In my MySQL server, I have rows that have the date of my created content. Example: 2013-03-17 02:53:47
For now, I am using:
$date = $fetch[thedaterownamegoeshere];
<?php echo $date; ?>
But ...
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 ...
1
vote
1answer
175 views
Getting the first day of week
In continuation of my previous question:
Get week/month data
I have a MySQL table with day column of type DATE and position column of type INT.
I need to fetch average position for every week in ...
2
votes
1answer
299 views
how to retrieve rows of different dates using IN clause
My table structure:
+-----------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
...
0
votes
1answer
47 views
UTC date in DMV dm_broker_queue_monitors
It seems that the DMV dm_broker_queue_monitors returns UTC time rather than local time. Why is it so?
I am wondering how to get local time from this view? I can get current time offset, but that is ...
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
2answers
3k views
Comparing date and timestamp variables in a where clause in a procedure
I have a variable in an Oracle stored procedure of DATE type (from user interface), and another of TIMESTAMP type (database is more precise than what the user would enter in the code that is executing ...
2
votes
2answers
661 views
Date format in SSRS
I'm wondering if there is a setting in SSRS to indicate the date format. We need to show the dates in dd/mm/yyyy format on the reports and from what I can see in database the value has been stored ...
1
vote
1answer
379 views
How to convert execution time to a specific format?
I am working on a report that allows people to print off data for physical signatures. Part of the requirement is to format the exectuion date in the format DDMONYY (27Aug12). I can not find a way ...
0
votes
2answers
168 views
Convert datetime to europe default without time
I have a datetime field that I need to convert into the format DDMONYY (27Aug12). I am currently using convert(nvarchar(30),DateToConvert,13), but that also spits out the time. How can I easily ...
0
votes
1answer
849 views
Converting Python's date format to a MySQL
First of all I hope this is the right place to ask.
I have a Python script which parses data from a few links. In the parsers I parse also the date of the last modified article.
This is the output ...
0
votes
3answers
187 views
Work out date difference when there is only one date
I have 2 records, one details when the stop clock was stopped and the other started. I only have the one date value in each record. I'm trying to work out the difference between the stop and start ...
2
votes
3answers
385 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?
4
votes
1answer
1k views
How to set Postgresql database to see date as “MDY” permanently
Ho can I set my database to see the 'date' as "MDY" without running:
SET datestyle = "ISO, MDY";
every-time I'm trying to access it?
I'm using Postgresql version 9.1, Ubuntu 12.04.
My system ...
1
vote
2answers
1k views
Setting NLS params in logon trigger don't work in oracle 11g
We have a trigger setup so that when a specific user logs in, their NLS session parameters are modified. This used to work on Oracle 10g. We've just migrated to Oracle 11g RAC, and the session ...
1
vote
1answer
524 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
...
1
vote
1answer
2k views
sybase format datetime yyyymmdd
This seems like something trivial would be easy, but I couldn't find a good way to do it.
This is what I came up with:
select convert(numeric,
(select ...
1
vote
1answer
78 views
How to prepare a date and double for a mysql replace statement?
I have a MySql table with three columns:
CU VARCHAR(3)
DA DATETIME
VA DOUBLE
I need to execute several REPLACE into mytable (CU, DA, VA) values("ABC", mydate, myval) statements from Java. mydate is ...
0
votes
3answers
1k views
Convert a Unix timestamp to a DATETIME in a View
I have a table that stores a unix timestamp. To query this as a date, I'm attempting to convert this timestamp to a datetime type in a view. Unfortunately, I can only seem to get the DATE portion out.
...
0
votes
1answer
904 views
MySQL: Why is DATEDIFF and TIMEDIFF/60.0/60.0/24.0 results different?
I have a database with two DATETIME values, and then I generate some new values from them:
tdiff = timediff(d1,d2)+0
day1 = truncate(tdiff/60.0/60.0/24.0,0)
day2 = datediff(d1,d2)+0
All three of ...
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 ...
1
vote
1answer
111 views
OVERLAPS for Informix
Does Informix have a function equivalent to OVERLAPS, which finds out whether or not two time intervals have any time in common?
8
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
...
2
votes
4answers
736 views
Best pratice to store dates group by months-year key par value
I am making one service which needs to hold data grouped and calculated by year-month combination. I know how to calculate data and put it on new table. But I am confused what kind of data type I ...
1
vote
1answer
2k views
YYYY-MM-DD has changed to YYYY-DD-MM after moving SQL Server to new domain how do I switch back?
I have moved the domain of my SQL Server and while everything is mainly working the date format for queries seems to have changed.
So if I run this:
select convert(datetime,'2012-02-13')
I get
...
2
votes
1answer
112 views
Varchar to date in SQL Server 2008 [closed]
I have varchar data in database table which stores date in DD-MM-YYYY format.
I want to select that varchar in MM-DD-YYYY format.
I'm using
select convert (varchar(30), (select CONVERT(datetime, ...
2
votes
2answers
971 views
Oracle Query by Quarter
I have a query that I want to get data from the past 5 quarters, but it doesn't work the way it should:
select to_char(eventdate,'YYYY') || ' Q-' || to_char(eventdate, ' Q'), ...
from ...
where ...
4
votes
2answers
529 views
Best way to handle dates prior to 1000 A.D. in MySQL?
I am creating a database for records that extend prior to 1000 AD, but MySQL Date and DateTime fields only support dates starting at 1000.
Is there a way that would be more convenient than either ...
2
votes
2answers
8k views
How to get the timestamp column in only milliseconds from PostgreSQL?
I have a column "created" with type timestamp without time zone default now() in a PostgreSQL database.
If I select colums, it has a nice and readable format per default:
SELECT created FROM ...
