well, really those varchar's could be way smaller
along the lines of (3) really. but not really necessary
since the overblown size really shouldnt/wouldnt cause
any negligible amount of overheard??
i wouldnt think, but
i could be wrong, thats for sure! jochem....would it?
later.
tw
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 1:23 AM
To: CF-Talk
Subject: RE: SQL Help
select (convert(varchar (255),m_month) + '/' + convert(varchar
(255),m_day)) + '/' + convert(varchar (255),m_year)) as date
from myTable
that is, if sqlserver is your database!
its the + sign plus the '' filled with whatever
delimiter you choose. The "CONCATENATOR" :)
hth
tw
-----Original Message-----
From: Cedric Villat [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 12:48 AM
To: CF-Talk
Subject: SQL Help
I have a database where the day, month, and year are stored as ints.
When I
select these 3 columns, I want to make them into a date. Something along
these lines:
SELECT (m_day, m_month, m_year) AS m_date
FROM myTable
Obviously that doesn't work, but is there a way to concatenate the 3
ints to
create a date in the select statement like that?
Cedric
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- RE: SQL help Ciliotta, Mario
- RE: SQL help Bruce, Rodney S HQISEC/Veridian IT Services
- sql help Wurst, Keith D.
- RE: sql help Bryan F. Hogan
- Re: sql help Jochem van Dieten
- Re: sql help Jamie Jackson
- RE: SQL help Dave Watts
- SQL Help Allan Clarke
- SQL Help Cedric Villat
- RE: SQL Help Tony Weeg
- Re: SQL Help Tony Weeg
- Re: SQL Help Donnie Bachan
- SQL Help Mickael
- RE: SQL Help Michael Traher
- Re: SQL Help Mickael
- RE: SQL Help Michael Traher
- Re:SQL Help Stan Winchester
- SQL Help Mickael
- RE: SQL Help Cantrell, Adam
- SQL Help Bruce, Rodney S HQISEC/Veridian IT Services
- Re: SQL Help Jeff Small