Sql Help

[shooter3]

Month to date SQL code kavali......

 

Output ila ravali

If today is 4/4

 

DATE              MONTH TO DATE

   4/1                          4/1

   4/2                          4/1

   4/2                          4/2

   4/3                          4/1

   4/3                          4/2

   4/3                          4/3

   4/4                          4/1

   4/4                          4/2

   4/4                          4/3

   4/4                          4/4

 

 

Thanks in Advance.

[loveindia]

anni saarlu duplicate avvala??? and also 4/1 ani raavala ? what is the actual requirement...

[vikuba]

clarity ledhu question lo...

[loveindia]

clarity ledhu question lo...

 

[Aryaa]

Simple man

To_char(<datefield>, 'MM/DD')

[loveindia]

Simple man

To_char(<datefield>, 'MM/DD')

 

sql antey pl/sql lo cheptaav nee yenkamma...

[Aryaa]

sql antey pl/sql lo cheptaav nee yenkamma...

That is SQL Funciton man

[loveindia]

That is SQL Funciton man

 

sql server / sql lo To_char anedi ledu man... sql server lo convert / cast vaadutaaru... Oracle Sql developer or pl/sql lo function adi... just google it man , thats it man...

[shooter3]

anni saarlu duplicate avvala??? and also 4/1 ani raavala ? what is the actual requirement...

this is just a class room assignment question.....

 

Month to date ravali......each day ki aa monh starting nunchi anni days chupiyali till that date

 

DATE              MONTH TO DATE

   4/1                          4/1

 

   4/2                          4/1

   4/2                          4/2

 

  2nd day of month kabati 1st day inka 2nd day ravali output lo ala......