|
Hello
I would like to sort a list of 1500 files in XSLT 1. The list is similar to:
01052003.xls -> (translate to: 1th of May 2003) 25062004.xls -> (translate to: 25th of June 2004) 31032001.xls -> (translate to: 31th of Marts 2001)
I can do a...
Started by Tillebeck on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Three sort keys based on the year, month, and day substrings of the date string:
<xsl:template:template>
What about reverse it?
<xsl:for-each select="dates/date"> <xsl:sort select.
|
|
So I've got a simple query in MySQL that sets a new member's expiration date once they pay their dues:
UPDATE members SET joined=CURDATE(), expires=DATE_ADD(CURDATE(), INTERVAL 1 YEAR), active='1' WHERE id=1000
this query has run 200+ times, normally ...
Started by Joel Broughton on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Those "wrong" dates didnt happen to be leap year dates did they....
Just a thought....
|
|
Hi,
I am experiencing a very strange behavoiour of Flex Date object. My web service is written in .Net 3.5 and all object which I am retriving or updating have Creation Date (Date Type) in .Net code.
But when I am calling .Net web service and displaying...
Started by Chandra P Singh on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I don't have an immediate answer, but some of the factors to consider are:
Is the date ambiguous? You didn't supply a sample of what the return might be, but a date like 09/10/2009 is ambiguous 21:22:00 GMT
The Date object in .NET....
|
Ask your Facebook Friends
|
New Date("05-MAY-09 03.55.50")
is any thing wrong with this ? i am getting illegalArgumentException
Started by Sunny Mate on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You should be using a DateFormat / SimpleDateFormat....
Date.html
You should
SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT); Date date = sdf.parse("05-MAY-09 03:55:50");
That Date constructor is deprecated for a reason.
|
|
I want to enforce CHECK constraint on a date range such that all dates in column BIRTH_DATE are less than tomorrow and greater than or equal to 100 years ago. I tried this expression in a CHECK constraint:
BIRTH_DATE >= (sysdate - numtoyminterval(1...
Started by Sajee on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
What you could do, if appropriate....
A check constraint expression has to be deterministic, so this sort of sliding date range that are not deterministic (CURRENT_DATE,
CURRENT_TIMESTAMP, DBTIMEZONE, LOCALTIMESTAMP a check constraint violation.
|
|
Very often I come across negative feedback on Java Date and other date-time-related classes. Being a .NET developer, I cannot fully (without having used them) understand, what's actually wrong with them.
Can anybody shed some light on this?
Started by Anton Gogolev on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Calendar c = Calendar.getInstance(); c.setTime(fistDate); c.add(Calendar.DATE,-1); Date....
First, to create a specific date, you use either do evil things like
Date firstDate = ...
Timespans, operator overloading) is very convenient.
|
|
I've had some bizarre results from queries I've been testing out with the DATE function, culminating in these little beauties:
mysql> SELECT id FROM job WHERE DATE(due)=CURRENT_DATE; Empty set (0.00 sec) mysql> SELECT id FROM job WHERE DATE(due)...
Started by Cebjyre on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
DATE(due) = CURRENT_DATE
I was able to reproduce the behavior where the comparison failed after purposes - a straight replacement of DATE with TO_DAYS seems to be going alright..
|
|
Hi All,
I have a GridView in ASP.net which is filled from an SqlDataSource.
one of the columns in the DB table is a Datetime which is set to 30/04/2009, when i show the grid view in asp it appears as 30/04/2009.(which is fine)
however when I hit edit ...
Started by Jambobond on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I suggest you set the DataFormatString of the column to {0:d} , which will display the date based on the page UI..
When date is bound to GridView, it is already a String and no more a DateTime .
|
|
I'm using Boost's datetime library in my project. I was very happy when I discovered that it has time duration types for hours, days, months, years, etc, and they change their value based on what you're adding them to (i.e. adding 1 month advances the...
Started by rmeador on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Instead of adding the *date_duration* object days , you should create a boost::posix_time::time , 0 , 0 ) ; //24 hours, 0 minutes, seconds, nano boost::local_time::local_date_time later = now + td ; //assuming that now is your starting /....
|
|
Why is PHP date("W") showing that the current week is 2? Shouldn't it be on week 3?
In the PHP documentation it says: weeks starting on Monday. Does that mean it just ignored the first 3 days of this year?
Started by Josh Curren on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
'); for($ts=strtotime('2009-12-27'); $ts<strtotime('2010-01-07'); $ts=strtotime('+1 day', $ts)) { echo date.
|
