SELECT nid, ti, url, event_dt, post_dt, extern FROM dbo.news WHERE convert(char,post_dt,112) between dateadd(mm, -#url.past#, convert(char,getdate(),112)) and convert(char,getdate(),112) and main = 'Y' ORDER BY post_dt desc SELECT * FROM dbo.seminars WHERE convert(char(12), date, 112) >= convert(char(12), getdate(), 112) order by date UCSD Department of BIOENGINEERING
Who We Are Faculty & Research Graduate Program Undergraduate Program Events & Seminars Positions Available Industrial Internship
Jacobs School of Engineering
Whitaker Institute of Biomedical Engineering
  Bioinformatics  
Systems Biology
BMES - UCSD Chapter BEGS - UCSD
#seminar.ti# - #seminar.speaker#
#LSDateFormat(date,"m/d/yy")# - #seminar.time#
#seminar.loc#
events/news/article.cfm?nid=#nid##url#" class="news">#news.ti#
>> More Seminars
>> Latest News

Department of Bioengineering

Who We Are | Faculty & Research | Graduate Program
Undergraduate Program | Events & Seminars | Positions Available
Contact | Help | Search | Site Map

Copyright©2001 Regents of the University of California. All rights reserved.
Last modified Wednesday, March 2, 2005
Contact Help Search Site Map