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

Your Answer:

Login to answer

Other forums

How to have a log of all the status a VIM document had been ?
Hi guys,

I’m using SAP Invoice Management plugin and the /OPT/VIM_ANALYTICS transa

SHOW TABLES Help
Hi all

I have the following

Code: [Select]<?php
$sql = "SHOW TABLES&quo

Sessions work for me and not others?
I'm having a bit of bad luck with sessions. In the past they have worked fine for me, but this time

Help with parsing this html
Hi,
I've got some html i just need a couple of strings from.. argh, it's freaking me out. I've t

retrieving policy name inside the function called by this particular policy
Hi there,

I've playing around with dbms_rls package, trying to set up some security repo

Bandwidth monitoring?
Hi guys,

I need a little information I have written a php app and I occurred to that I need

Keep newlines from textarea?..
I'm creating a simple encoding program, and what I want it to do is retain the newlines, as echoing

Tracking Unique Clicks
Hi guys and gals,

Basically I have a database which tracks clicks on my outbound links, I do

Array help
Hello i got this code to fetch data from database but it is not working it displays
7
Array

first id from db not showing
I have a php script which displays the content of a mysql table as a html table with sorting, delete