Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Convert characters to numeric with query400

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Convert characters to numeric with query400

    Hi, I have a query that summerize a file and makes a new-file. In this new file i have a field breaklvl and a total-value of a field. Can someone tell me if it is possible to convert the content of the field 'breaklvl' of the query400 into a numeric (Ex 2,0) value using Query400 ? I tought it could be done by using a new-defined field using something like microseconds, but i can not remember me how to do it ?

  • #2
    Convert characters to numeric with query400

    Doeraene Jean-Pierre wrote: > Can someone tell me if it is possible to convert the content of the > field 'breaklvl' of the query400 into a numeric (Ex 2,0) value using > Query400 ? I tought it could be done by using a new-defined field > using something like microseconds, but i can not remember me how to > do it ? This is the syntax: microsecond('2000-02-18-01.01.01.' || charfieldname) The first part is just any date time stamp then follow it with a character field. Bill

    Comment

    Working...
    X