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 Casey C Cook
- Re: SQL help Casey C Cook
- 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
- RE: 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