Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with date conversion

Status
Not open for further replies.
ericwarner63

ericwarner63

Technical User
Oct 16, 2002
2
US
We are having issue with the follwing data conversion...

We want to change this:

row_date starttime acd
--------------------------- --------- ------
2002-08-11 00:00:00 1730 1
2002-08-15 00:00:00 2000 1

into:

01 | 20020811 | 1730
01 | 20020815 | 2000

etc...

We want to concantenate acd with a leading zero in under 10, row_date with no time, starttime...

I'm having issues with the '+' function because the numbers are added to the date...

Thanks in advance..
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
193
mmiah1982
mmiah1982
fredong
  • Locked
  • Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
247
carp
carp
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
144
mikrom
mikrom
manbob
  • Locked
  • Question
need a help with sub query getting group ereor, please correct
Replies
2
Views
196
carp
carp
jchewsmith
  • Locked
  • Question
Update Query with a MAX(Date) subquery 1
Replies
1
Views
240
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top