|
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
|
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.
|
|
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.
|
|
I have the following code
public boolean processCell(boolean hasData, StringBuffer rowData, Cell cell) { switch (cell.getCellType()) { case Cell.CELL_TYPE_FORMULA: { try { this.evaluator.clearAllCachedResultValues(); switch (this.evaluator.evaluateFormulaCell...
Answer Snippets (Read the full thread at stackoverflow):
The wrong result some times but get right result most of the times i am not able to understand.
|
|
Hi there,
can anyone help. I have recently moved servers, its IIS7 rather that our previous IIS6 but everything else is the same, i have set the region to the UK and all date formats plus system local .. I mean everything ..
But when a webpage asp.net...
Started by mark smith on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Make sure you have also ticked the box in Regional and Language Options (Advanced tab) to say "Apply all... .
Check the localization options on the box and see what it is set for--someone probably just selected en-US for the setup and forgot to tell anyone .
|
|
I'm such a clot. I just booked an advance, and after the site crashed first time around I managed to pick the wrong date when rebooking.
Given I have only just booked this (in the last hour) - is there any leniency in getting it changed without a fee?...
Started by Belly Buster on
, 15 posts
by 11 people.
Answer Snippets (Read the full thread at railforums):
An Advance ticket for the wrong date due to the date defaulting back and me not checking booked for the same date a month later.
|