I want Date Format

[suneel kumar]

Hi All,

i want dateformat.

Example:

Input(200603) here year month


output(20060301) Here year month day

here every time day start on 01 by default in output.

Thanks in advance,

suneel

[ray.wurlod]

It's not clear WHERE you want the date, nor whether you want to generate dates.

Certainly converting from 200603 to 20060301 is very simple; you make use of the fact that there are no data types in server jobs, and concatenate the "01".

But I suspect there is more to your question than that. Do you, for example, need to generate a sequence of dates? If so, is it only for the month in question, or for a potentially longer period?

There are solutions to all these variants, but we would like to be fully cognizant of your actual requirement.

[ameyvaidya]

Hi Suneel,
If the input is string (varchar or Char), You can just append the '01' to the end of the input.
IHTH