datetime

How can I convert my DateTimeOffset to a Twitter Date/Time ?

Hi folks, How can I convert a DateTimeOffset.Now into a twitter-compatible date/time? Twitter example: <created_at>Tue Apr 07 22:52:51 +0000 2009</created_at> cheers :) ...

Mapping java.util.Date to xs:date instead of xs:dateTime in JAX-WS

Hi all, We hav an EJB, jws-anotated as a web service. It has a pretty complex pojo-model that generates an equally complex xsd. The pojos contain numerous java.util.Date. These all map to xs:dateTime. This service is used as "business service" in Oracle(BEA) OSB(AquaLogic). We also have a "proxy service" which we map to the BS with XQ...

how to get Next month date from today date (i.e) exactely one month expires from today date

i have maintained two datas into my table 1 column 2 column PaidDate validitydate in padidate ill give insert todaydate. but in validity date i may either insert validity for 1 week/1 month. I have used validity=DATEADD(Day,7,@paiddate) to insert validity for 1 week. but how to gtet the validity for 1 month from todays date ...

Find objects between two dates MongoDB

I've been playing around storing tweets inside mongodb, each object looks like this: { "_id" : ObjectId("4c02c58de500fe1be1000005"), "contributors" : null, "text" : "Hello world", "user" : { "following" : null, "followers_count" : 5, "utc_offset" : null, "location" : "", "profile_text_color" : "000000", "friends_...

Whats wrong with DateTime object

Hi, Can anyone tell what is wrong with the code. $timezone = "Asia/Karachi"; $date = new DateTime($when_to_send, new DateTimeZone($timezone)); $date = $date->setTimezone(new DateTimeZone('GMT')); $when_to_send = $date->format('Y-m-d H:i:s'); error is: Call to a member function format() on a non-object ...

Calling C++/CLI Method with System::DateTime parameter requires 'ValueType' as a parameter?

I'm attempting to call a method written in C++/CLI from C#. The C++/CLI code is used to update a TIMESTAMP column in an Oracle database, given a record ID and the System::DateTime object which is the .NET compatible data type for Oracle's TIMESTAMP type. The method I am calling has the following prototype: bool ChangeJobUpdateDate (int...

How to change TXSDateTime SOAP serialization in Delphi 7?

I am trying to use Java based webservice and have soap request: <?xml version="1.0"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"&gt; <SOAP-ENV:...

mysql : Recieve data only per months

Hello, few times ago, i asked how to do to display datas per month, i must told a bad explanation because i just figured out that it's not what i want : Here's what I got : $req1 = ... AND v.date > (DATE_SUB(CURDATE(), INTERVAL 2 MONTH)) AND v.date < (DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) $req2= ... AND v.date > (DATE_SUB(CURDATE()...

Inserting a Date and Time value to a MySql from PHP

Hello i want to send to a MySQL data base a date and time in a format compatible with the mysql DateTime format, wich is: 0000-00-00 00:00:00 ... Im using this code who brings the date and time from a PHP command: $insert = "INSERT INTO sms (ref, texto, fecha) VALUES ('".$_POST['usuario']."', '".$_POST['sms']."', '".date(DATE_ATO...

How to Open a Directory Sorted by Date?

How to Open a Directory Sorted by Date? In C#, I can open a directory for reading each file. How to I make sure that the directory I investigate in my C# code is opened such that it is sorted by last modified date? ...

PHP Date Manipulations

I need to get previous 30 days from a specific date which is available from database(eg: 2010-05-23 12:36:29).I am try it by using date('d', strtotime("-30 days")) Which is getting the currect answer what i looking for but it is not help me to enter date from database.Please help me to solve the issue. ...

VS2003 asp.net web service accepting wrong xmlschema datetime

Has anyone noticed that a web service build with vs2003 accepts datetime parameters with a wrong format, even though the wsdl says it has to be a xmlschema datetime? E.g. 31-05-2010 Why is that? ...

Parsing French Date

I am trying to parse a french date to a DateTime object with no luck so far. Is there a way? to do that. String foo = "mar, 20 avr 2010 09:00:00 -0500"; I've Already tried parsing with a different culture and changing the culture of the thread. System.Threading.Thread.CurrentThread.CurrentCulture = new CultureInfo("fr-CA",true); Cult...

Which Perl moudle can handle variety of date formats with unicode characters ?

My requirement is parsing xml files which contains wide varieties of timestamps based on the locales at which they are written. They may contain Unicode characters in case of Chinese or Korean locales. I have to parse these timestamps and put then in a standard format something like 2009-11-26 12:40:54 to put them in a oracle database. S...

DateTime Comparison Precision

I'm doing DateTime comparison but I don't want to do comparison at second, millisecond and ticks level. What's the most elegant way? If I simply compare the DateTime, then they are seldom equal due to ticks differences. ...

DateTime Format Strings?

I have the date format string dd-mm-yy. Please can you tell me how to add hours and minutes to the string (i.e 13-03-2010.21.03) .... DateTime.Today.ToString("dd-mm-yy") ? ...

Date formats in ActiveRecord / Rails 3

In my model, I have a departure_date and a return_date. I am using a text_field instead of the date_select so that I can use the JQuery datepicker. My app is based in the US for now but I do hope to get international members. So basically this is what is happening. The user (US) types in a date such as 04/01/2010 (April 1st). Of co...

seemingly complex date time calculations...

I have this function that should convert them from Ole to UTC8601 standard, but I don't understand how the integer representations of time seem to work. Can anyone give me some explanation? the function is called: RipOf_AfxTmFromOleDate containing statements as: nDaysAbsolute %= 146097L; Where does the value come from and how is it c...

Formatting dates when serialising an object in C# (2.0)

Hi, I'm xml-serializing a object with a large number of properties and I have two properties with DateTime types. I'd like to format the dates for the serialized output. I don't really want to implement the IXmlSerializable interface and overwrite the serialization for every property. Is there any other way to achieve this? (I'm using...

Which DateTime module is best for manipulating an XML date and time

I am trying to parse a date from a GPX (XML track format) that looks like 2009-08-02T12:11:06Z My initial approach was to use DateTime::Format::RFC3339 But DateTime:Format::XSD seems to do a similar job. Is there a difference between the applicability of these modules. ...