> SELECT TimeValue([answered_message_date]) AS Time_of_problem,
> DateValue([answered_message_date]) AS date_of_problem
> FROM messages
>
>I really just ned to seperate the date from the time
Eron
SQL Server has a function called DATEPART which takes 2 arguments,
the second of which is a datetime. The first can be yy for year,
mm for month, dd for day, hh for hour, mi for minute etc.
eg datepart(mm, answered_message_date) gives you the month.
HTH
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
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.
