I am in the process of upsizing an old website to SQL Server from MS Access.
I've run into a problem where the old site uses an MS Access-native function
that SQL Server does not seem to have:
SELECT TimeValue([answered_message_date]) AS Time_of_problem,
DateValue([answered_message_date]) AS date_of_problem
FROM messages
Does anyone know of a way I could get the equivelent values using a SQL
Server function? The field "answered_message_date" is a datetime field,
for example: 7/11/00 3:59:02 PM . . . I really just ned to seperate the date
from the time (but I DO need to do so in the query itself, I can't do it
after the fact because this data is being UNIONed with another table that
DOES have these fields seperate.)
Thanks for any ideas.
Eron
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
