Thread View: borland.public.interbase.sql
5 messages
5 total messages
Started by Andrew Jameson
Wed, 27 Nov 2002 14:15
Handling Dates
Author: Andrew Jameson
Date: Wed, 27 Nov 2002 14:15
Date: Wed, 27 Nov 2002 14:15
5 lines
1066 bytes
1066 bytes
Hi, I'm using SQL Dialect 1 and sadly the Date function returns the time as well ... I only want the date ... how do you do it ? Andrew
Re: Handling Dates
Author: Antonio Felix
Date: Wed, 27 Nov 2002 14:34
Date: Wed, 27 Nov 2002 14:34
16 lines
1304 bytes
1304 bytes
"Andrew Jameson" <contact@softspotsoftware.com> wrote:
>Hi,
>I'm using SQL Dialect 1 and sadly the Date function returns the time as well
>.... I only want the date ... how do you do it ?
>
>Andrew
>
>
Hi,
Have you tried
CAST( YOURDT as DATE )
HTH
Antonio
Re: Handling Dates
Author: Craig Stuntz TeamB
Date: Wed, 27 Nov 2002 14:35
Date: Wed, 27 Nov 2002 14:35
14 lines
1508 bytes
1508 bytes
In article <3de4d2d0@newsgroups.borland.com>, contact@softspotsoftware.com says... > I'm using SQL Dialect 1 and sadly the Date function returns the time as well > ... I only want the date ... how do you do it ? > You only want the date in which context? -Craig -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Re: Handling Dates
Author: Andrew Jameson
Date: Wed, 27 Nov 2002 15:30
Date: Wed, 27 Nov 2002 15:30
31 lines
2284 bytes
2284 bytes
Hi Guys ... Thanks Craig ... I tried that Cast but it doesn't work ... essentially I wanted to truncate the TimeStamp to eliminate or zero the time ... it's an inherited database port from SQL Server and although I don't need the time, the data is populated with non-zero time ... consequently equality tests involving dates can become dependent on the time ... which I don't want ! Solved it anyway ... shifted it to Dialect 3 and converted all of the TimeStamp definitions to Date ! Andrew Craig Stuntz [TeamB] <cstuntz@nospamplease.com (but use vertexsoftware to email)> wrote in message news:MPG.184ea22a727a113d98a28a@newsgroups.borland.com... > In article <3de4d2d0@newsgroups.borland.com>, contact@softspotsoftware.com > says... > > I'm using SQL Dialect 1 and sadly the Date function returns the time as well > > ... I only want the date ... how do you do it ? > > > You only want the date in which context? > > -Craig > > -- > Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH > Delphi/InterBase Weblog : http://delphi.weblogs.com > InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor > InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Re: Handling Dates
Author: Craig Stuntz TeamB
Date: Wed, 27 Nov 2002 16:01
Date: Wed, 27 Nov 2002 16:01
14 lines
1536 bytes
1536 bytes
In article <3de4e44e@newsgroups.borland.com>, contact@softspotsoftware.com says... > Solved it anyway ... shifted it to Dialect 3 and converted all of the > TimeStamp definitions to Date ! > This is the *best* solution, IMHO. -Craig -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads