Current Position:Home > Date Field (MON-YYYY)

Date Field (MON-YYYY)

Update:11-30Source: network consolidation
Advertisement
Can somebody help me to display and enter in date field like MON-YYYY.So it will save also like that in database.

The Best Answer

Advertisement
User,
What is your name?
Dates are not stored like that in the database. Dates in the database store both date and time with accuracy up to seconds. You can "truncate" a date field to fit your needs and then format it when you need to display it. In your example you only need accuracy up to the month so you could store a date as TRUNC(SYSDATE, 'MONTH'). Note that this would be saved as 01-FEB-09 12:00 AM.
However, TRUNC is not needed if you create a date without that accuracy to begin with as in TO_DATE('FEB-2009','MON-YYYY'), this would be the same as above.
Regards,
Dan
http://danielmcghan.us
http://sourceforge.net/projects/tapigen
  • Date Field (MON-YYYY) Update:11-30

    Can somebody help me to display and enter in date field like MON-YYYY.So it will save also like that in database.User, What is your name? Dates are not stored like that in the database. Dates in the database store both date and time with accuracy up

  • IDoc posted in R/3 but data for Date field has not generated. Update:10-11

    Hi Experts This is JDBC to IDoc scenarion. Source: MS SQL Server Date Data Type: smalldatetime Date field Format: yyyy-MM-dd hh:mm:ss --> example: 2009-11-13 00:00:00 XI Mapping: Source Date --> Transformation --> Target Date Transformation: yyyy

  • How to display date field in ALV in format 'YYYY-MM-DD'? Update:10-11

    Hi experts, I am not getting displayed the date field in ALV in the format 'YYYY-MM-DD' if it is different than my user setting's format (DD.MM.YYYY). Tried with the edit mask LVC_S_FCAT-EDIT_MASK = '____-__-__'  but it does not work. I could not fin

  • IR Date Filter - My date field is MM/DD/YYYY users want to filter by same Update:11-30

    Hi, I have a interactive report that has a date field and I put a "MM/DD/YYYY" display format on it. The filter uses DD-MON-RR format in filtering which works fine but the users want to filter by same format of MM/DD/YYYY because they want to ty

  • How to convert a date field with format (dd,mm,yyyy) to format (mm,dd,yyyy) Update:11-30

    Hello. How to convert a date field with format (dd,mm,yyyy) to format (mm,dd,yyyy) I have text field which has a databind to a date field. When I click on it, we can select the date, it is added on the format (dd,mm,yyyy). When I want to insert this

  • Date field in DD.MM.YYYY format printing as MM.DD.YYYY Update:11-30

    HI all, There is a DATE field FKDAT in an invoice whose value is in DD.MM.YYYY format (01.07.2010). In the print program, this value is being passed into a CHAR field. However, when it gets printed it prints in MM.DD.YYYY format (07.01.2010). I have

  • Compound date (dd.MM.yyyy HH:mm) from two input fields Update:11-30

    Hi, I need to compound a date field in format dd.MM.yyyy HH:mm from two input fields(date and time field). I was trying a lot but could not get it to work. So right now I'm trying to start it simple but still have a couple of problems. 1.) To start e

  • Select -option Date field in MM/YYYY format! Update:11-30

    Hi.. Friends..    Iam having DATE field as selection screen SELECT_OPTION parameter. And I am fetching records from one of my tables with where condition of this select-option. Now my reuirement is to modify that DATE select-option with 7 characters

  • How to add a mm-dd-yyyy date field type in a Planning Data Form Update:10-11

    Hi John, pls, I have one question regarding the possibility of adding a date field type for example 03-03-2009 in a cell of Planning Data Form application. for example, I created: - 2 members in Period dimension: StartProject and EndProject and I nee

  • DATE fields and LOG files  in context with external tables Update:10-11

    I am facing two problems when dealing with the external tables feature in Oracle 9i. I created an External Table with some fileds with the DATE data type . There were no issues during the creation part. But when i query the table, the DATE fields are