Subject: | Re: SQL DATE + TIME
| Date: | 28 Sep 2020 06:16:39 -0400
| From: | "Thies Grimm" <thies.grimm@t-online.de>
| Newsgroups: | pnews.paradox-client_server
|
thanks!
Mark Bannister <markRemove@THISinjection-moldings.com> wrote:
>I think you are going to have to format them as strings and stick them
>together in the expected format.
>In local SQL this works: CAST('9/8/2020'|| ' ' || '01:02:03 AM' AS
>TIMESTAMP)
>so you may need to cast your date and time as character and then stick
>them back together.
>
>CAST(
> CAST(fldDate AS CHARACTER(10))
> || ' ' ||
> CAST(fldDateTime AS CHARACTER(10) )
>) AS TIMESTAMP)
>
>On 9/23/2020 10:49 AM, Thies Grimm wrote:
>> Hi, in my table there are two fields, one date and one time field.
>> I like to add these both values to a single field datetime.
>>
>> SQL
>> SELECT (fldDate + fldTime) AS fldDateTime
>> endSQL
>>
>> doesn't work (Type mismatch in expression)
>>
>> So I tried
>> SQL
>> SELECT (CAST(fldDate AS TIMESTAMP)
>> + CAST(fldTime AS TIMESTAMP)) AS fldDateTime
>> endSQL
>>
>> Same error
>>
>> So how do I do it?
>>
>> Thanks
>>
>
|