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
Did you know?Explore Trending and Topic pages for more stories like this.

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

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thoug

PHP using IF to display error
i have a MySQL query and i want to display 1 thing only if the number of affected rows is >=1

replacements
I have a variable in my PHP script like

ASSFDDDDDDDDDDDDDASDDDDDDDDARYTRHKKHHHHHHHHHHH and p

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

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

Beginners syntax and loop questions - help please!
Hi everyone,

I have some problems with php code. I'm currently in the middle of learning php,

Getting number of affected rows in SQLPLUS..
Hi everyone,
I have a shell script where i am invoking sqlplus, running a query and saving t

Compare user input to flat file data
Help...Am a complete newbie to programming so my code is prolly quite long. Am trying to verify a us

Multidimensional $_POST
Hello

How to get a single array from array of array (2 - dimension).
For example I have a

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