SQL TIME conversion

Original Message

Name: sharitha
Date: May 8, 2006 at 07:34:45 Pacific
Subject: SQL TIME conversion
OS: UNIX
CPU/Ram: 512
Model/Manufacturer: HP

Comment:

Hi,
I have an issue i need to display a date say (14-sep-2005 11:20:00) as 14-sep-2005 12:20:00) and (22-dec-2005 11:20:00) as (22-dec-2005 11:20:00). As of now my oracle SQL is showing these 2 as 11:20.I am not able to figure out the exact conversion to make this happen.Has this got anything to do with the time change.

-Shari

Report Offensive Message For Removal

Response Number 1

Name: jhunt303
Date: May 8, 2006 at 09:30:51 Pacific
Subject: SQL TIME conversion

Reply: (edit)

Do you have your Query to hand?

Report Offensive Follow Up For Removal


sql find totalprocess time of doc SQL - get difference between rows SQL *Plus Help SQL Server Express svc won't start. Run-Time error '3141'	sql server update Need help with SQL-query (access) SQL Errors Installing SQL version over trial sql syntax problem

Merging DB's in Access

ACT! 2000 randomly runnin...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: SQL TIME conversion

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL: