Posted by Simon Hayes on 09/08/05 21:13

"v0lcan0" <UseLinkToEmail@dbForumz.com> wrote in message
news:4_877989_087c9582517dd6a1f7813c2a746cac72@dbforumz.com...
> Any help on extracting the time part from the datetime field in SQL
> database.
>
> even though i had entered only the time part in the database when i
> extract the field it gives me only the date part. i'm using Vb.net
> datagrid as a front end.
>
> any assistance appreciated!! :?:
>
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/General-Discussions-Extracting-Time-SQL-DateTime-field-ftopict254266.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=877989

See CONVERT() in Books Online:

select convert(char(8), getdate(), 108)

For more general information about working with datetime data, see here:

http://www.karaszi.com/sqlserver/info_datetime.asp

Simon

[Back to original message]