SQL script for date conversion

comp.databases.gupta (1995-2015)

SQL script for date conversion

Post by Don » 04 Apr 2001, 16:22

 Posted by:  hcri...@hotmail.com (Don) 

Hi everyone,

Recently I have ran across a date/time conversion problem that I am
hoping you will help me solve using the Gupta sqltalk script language.
What we have is a field that is a coded date and time, and I need to
compare it to a date for a select statement.

As near as I can figure, this date/time field is represented in number
of seconds since a particular date format (IE: 984674026 would be Mar
15, 2001, at 4:33PM, 98590973 would be Mar 30, 2001, at 11:16AM).

What I would like to do is have some type of comparison between a
normal date format and this field during a select statement (IE:
WHERE mydatetimefield=04/04/2001).

Any ideas on how I could make this conversion?

Thanks in advance,


Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot] and 0 guests