Re: convert date

From: P.Hill (goodhill_at_xmission.com)
Date: 04/02/04


Date: Thu, 01 Apr 2004 23:18:01 -0700

Jason wrote:
> Help. please.
>
> data in database:
> 2004-03-31 10:11:20 PM
>
> output required:
> 04/01/04 00:11:20

But you said you wanted MST to EST conversion right?

> I have no problem convert 2004-03-31 10:11:20 PM to 03/31/04 22:11:20
> but how can I added two hours to the output string so I can get 04/01/04
> 00:11:20?
> I have tried Calendar.add, but got error message, so please help,

Where you going to tell us the error message or just leave us to guess?
-Paul



Relevant Pages

  • Re: access 97 to 2000
    ... Access database. ... > conversion does not change the original file. ... I recall that after ... I do not recall the exact wording of the error message, ...
    (microsoft.public.office.misc)
  • Re: invalid argument
    ... also may want to ensure the database has been split. ... "kathy" wrote in message ... > datasheet view' error message. ... Does this sound like conversion problem? ...
    (microsoft.public.access.conversion)
  • invalid argument
    ... Converted an Access 97 database to Access 2000 about a ... datasheet view' error message. ... Is there any method besides restoring from backup tape ... Does this sound like conversion problem? ...
    (microsoft.public.access.conversion)
  • Re: Acc97 to Acc2007 conversion
    ... Then create a new database in Access 2007, and *import* everything rather than asking it to convert the database. ... "The database cannot be opened because the VBA project contained in it ... Access seems to do some sort of conversion, ... I've seen this error message in other discussion threads in regards to ...
    (comp.databases.ms-access)
  • Re: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS
    ... one which you could fix by removing the database). ... The bug report is below. ... > Informix Server Entries in sqlhosts file ... > # Error Message: ...
    (perl.dbi.users)