Amicuk Programming Answers

Date Formating

-0001-11-30   Views:0


Hi , I have a date in this format Apr 11,2002 . I would like to convert it to 4/11/02 and vice versa. Can anyone give a hand on this. thanksuse java.text.SimpleDateFormat See api doc for details. Use format() and parse() method to convert date. Examp

Hi ,
I have a date in this format Apr 11,2002 . I would like to convert it to 4/11/02 and vice versa.
Can anyone give a hand on this.

The replay answer
use java.text.SimpleDateFormat
See api doc for details. Use format() and parse() method to convert date.
Examples of patterns and results from API doc:
Date and Time Pattern  Result 
"yyyy.MM.dd G 'at' HH:mm:ss z"           2001.07.04 AD at 12:08:56 PDT 
"EEE, MMM d, ''yy"                              Wed, Jul 4, '01 
"h:mm a"                                             12:08 PM 
"hh 'o''clock' a, zzzz"                            12 o'clock PM, Pacific Daylight Time 
"K:mm a, z"                                         0:08 PM, PDT 
"yyyyy.MMMMM.dd GGG hh:mm aaa"  02001.July.04 AD 12:08 PM 
"EEE, d MMM yyyy HH:mm:ss Z"         Wed, 4 Jul 2001 12:08:56 -0700 
"yyMMddHHmmssZ"                            010704120856-0700 

Go to See the other 2 answers

Problem with Date formatting

Category:DefaultRelease time:2015-10-11Views:130

Hi Tim, I am facing some issues with formatting the date using XMLP. The following is the sample XML data file i am using: <LIST_G_HEADER> <G_HEADER> <QUOTE_HEADER_ID>1455</QUOTE_HEADER_ID> <QUOTE_NUMBER>2027</QUOTE_NUMBER[More]

How can we give the Data Format (File Type ) in Runtime

Category:DefaultRelease time:2015-10-11Views:130

Hi all, How can we give the Data Format (File Type ) in Runtime for the following method, cl_gui_frontend_services=>gui_download. Thanks in advance SriThere is a filetype parameter which you can set CALL METHOD cl_gui_frontend_services=>gui_download[More]

Need to convert into date format

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I need to convert '2008-11-26T11:07:38-06:00' [YYYY]-[MM]-[DD]T[HH]:[MM]:[SS][TIMEZONE] in format 'YYYY-MM-DD HH:MM:SS'. Thanks in advance.> Thank you for your reply But it is giving me output as '26-NOV-08' And I want in format '2008-11-26 0[More]

Changing date format at reporting level

Category:DefaultRelease time:2015-10-11Views:130

Hello, Will u plz tell me how can i change the date format at reporting level? I want to display date in dd/mm/yyyy, but by default its showing mm/dd/yyyy. Delta is already loaded in the system, so i don't want to disturb regular data loading. Is the[More]

How to convert the numeric to date format

Category:DefaultRelease time:2015-10-11Views:130

HI ,      We have created the date KF and selected the data type as DEC-numeric or counter and add in the cube.       the data for this fields in the cube are in numerics like  734.504, but when we execute the report it is converted in to date format[More]

How to get Date Format from Local Object.

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am new to Web Channel. I need to know Date format From date of locale. suppose there is a date "01/25/2010" date in date field I want to get string "mm/dd/yyyy". Actually I have to pass date format to backend when I call RFC.[More]

How to change default Date format in BO 6.5 SP4

Category:DefaultRelease time:2015-10-11Views:130

A problem with date display has been reported to me by one of our users -  in BO 6.5 - since installing SP4. The default date format is now MM/DD/YYYY I have tried to recreate this on my PC and have been able to confirm that this is the case. Most of[More]

Date format issue in oracle database

Category:DefaultRelease time:2015-10-11Views:130

Hi, Back end : Oracle Front end : Forms 11g In our application we are facing issue with TO_DATE('DD/MM/YYY') Date format conversion. Example: TO_DATE(P_date,'DD/MM/YYYY') giving the result as 20-Dec-0009 In the above eg the Parameter P_dat[More]

Problem with SQL*Loader and different date formats in the same file

Category:DefaultRelease time:2015-10-11Views:130

DB: Oracle Database 10g Enterprise Edition Release - 64bi System: AIX Hello, I'm using SQL*Loader to import semi-colon separated values into a table. The files are delivered to us by a data provider who concatenates data from diffe[More]

Problem with date format mask 'D'

Category:DefaultRelease time:2015-10-11Views:130

I am experiencing an extremely thorny problem with the date format mask 'D'. I am trying to use it to check whether today is a Monday. The variable v_temp_day is set to sysdate. For the last 4 weeks the code has behaved erratically – giving a differe[More]

Problem with date format when ask prompt web-intelligence

Category:DefaultRelease time:2015-10-11Views:130

Bo XIR2 with 5 SP. Instaled on Windows 2003 with support Russian. Inside BO every labels, buttons - use russian. But when invoke web-report and Prompt appear there is problem with date format. Looks like korean format of date ' H:mm:ss'.  I[More]

I recently bought the new iMac as my older Windows based computer crashed with a bad motherboard.  I have been trying to find a way to convert Outlook 2007 pst files to Mac Mail without the need to use a Windows based computer since all I have now is [More]
I am currently coding on a JSP program, which searches the database and writes the resultset into a file on the server, and then allows the client to download this tab delimited text file onto their local machine. But I met a problem, when the defaul [More]
Dear Apple - I am a web developer and a beginning fiction author... I love my macbook... I am planning to get a ipad with the Pages App soon (upgrading to a Macbook Pro first). I am also an owner of the iphone 4, and therefore have explored ibooks. H [More]
I have films from DVD's I just want to know how to put them on my iTunes or IPod?When you go to Get Info and add artwork, you're only adding artwork for the particular track you selected. If you go back to the initial track to which you added artwork [More]
Hi All, I have a question for you. Using version I was playing with a use case where I need to show and hide columns in an af:table component. I want to do this clientside using javascript. Guess what: It works, however, it only works for h [More]
I'm trying to use an XA topic connection factory in my MDB, I was getting a "not supported in this release" error until I added this annotation to my MDB: @MessageDrivenDeployment( resourceAdapter = "myProviderInstance" But now my MDB [More]
Hello, I have a scenario, where i need to migrate SQL 2005 servers db's ( around 30, small ones) to new server in a new domain. Destinationserver is 2012 R2, running SQL2014 Domains have trust between them, and users have already been migrated to new [More]
when I print I have what seems to be some random faded 'boxes' appear in the background. They seem to be related to elements which have a drop shadow or transparency applied to them. I have changed 'All Spots to Process' in the ink manager as that fi [More]
hello there everyone, hope i got the title right.., so here goes the problem i need your opinion and help to solve: application definition: i have this desktop flash application that will go fullscreen what this application do is loading external ass [More]
OS:AIX 5.2 OS: Linux 86 E.G: echo $OARCLE_HOME /opt/oracle/product/10.1.0/database I am applying Patch 4505133_10105 on my above two servers. I have downloaded or and move to /opt/oracle. In my uderstanding , I should [More]