Help on query replacing the date


Posted on 16th Feb 2014 07:03 pm by admin

Hi Pals,

i want to replace the current date in a column to some value say C or D or any numeric value , likewise the NVL function which replaces the null value can i replace value selected to my assigned value
eg

select * from employee where employeedate= current dat will display the dates as 2008-10-10 to C or D

No comments posted yet

Your Answer:

Login to answer
56 Like 54 Dislike
Previous forums Next forums
Other forums

RFQ Configuration - can you make PLANT field an optional field in ME42
Is there a way to make the plant field on an RFQ optional in change mode (ME42)?

Captcha problem users just refresh and it will let them auto submit again
Users will just re submit and not have to enter the new captcha.. ? Lol but if i refresh the page, t

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

PHP switch function help
Hi, I am trying to create a search function for a directory website. On the search function on html

MySQL issue
I am taking sentences through a form on page. Then checking some condition and trying to insert them

Need Help with a query
Hello,
For some reason I am just not getting the right answer when I do this query and not quite

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

Performance impact of cookies
Hi, I was just wondering what impact there would be in terms of performance if you where to set then

how do i make a string??
hey guys,
can someone please tell me how to put data from the glob function into a string

Multiple Options for a Single Page
For this example I want to use the Handlers option which is under Fed Admin and all the related codi

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash